Security questions - need to start adding users

[Godofbeer2]

Folks:

I inherited a working MS-Access 2003 database which has been working for several years in a networking environment. Now, I have to add a few users and give them read-only rights. The database currently does not have any users and when you load it, the database loads up without a password prompt.

I'm looking for some advice in the best way to do this because what I've been reading has confused me. So far I seem to have found the following 3 ways to acheive user level security:


1.) User-level security wizard
But this results in the creation of a separate security file

2.) Just add users in the Users-and-group-accounts section

3.) Create a workgroup in the workgroup administrator option
This appears to create separate files as well.


Seems to me that if I just want to create a few read-only users, option #2 is the easiest.

Can someone with experience in this area offer advice as to why one option is better than another?

Thanks,

W.

 

[odin1701]

I use a user access table with usernames and rights levels, then enable/disable menus and thing depending on that.

For those users I would have a form open as read only.

You'll have to implement security for everyone though unless you only limited users if they were in a table, otherwise they get everything, though I usually don't like to do that.

 

[Godofbeer2]

Thanks for reply. Sounds as if you have to insert code somewhere referencing the current user versus the table/object they want to access. It looks a little bit beyond my Access capabilities