user logon

[bseche]

I'm new in user the security option in Access 97.

i have about 100 users that needs to be able to login into this database. Can someone give me some pointers on how to get started. Or maybe a link that can help me. I did setup the access password. How is that different in database password. Why would i want to setup a database password. Also some info on setting up password for a form.
Much thanks

 

[The_Doc_Man]

Look up help on the subject of Workgroups. Also "Securing a database." That should get you started.

You can grant accounts to folks with unique usernames and passwords. Each username can have totally different rights to the contents of the database if necessary.

Some words of advice:

Don't use SYSTEM.MDW as the name of the workgroup file, pick another name.

Pick any scheme you want (but pick one!) for defining personal IDs. Even just a sequence number, anything!

While you certainly CAN give rights to each individual, you would do better to assign the rights by some sort of grouping, then put each individual in one of the groups. That way, they inherit the rights of the groups and there are fewer steps in preparation for setting up rights.

It can be tedious to retrofit user/group rights to a database full of various objects, but you only have to do it once if you do it right. That includes setting the appropriate rights on the <new object> that always proceeds each list of objects of the same class in the Permissions screen.