Multi User login for Access 97

[mabaulza]

I have a multi user DB with no login at the moment.

There are 2 types of users, Admin (3 members of staff) Users (40+ staff). I would like for the users to input their personal login details and once accepted, for one form to automatically open and maximise (Request_form) but dont want them to access any other part of the DB (ie not table, form queries, toolbars etc)

When the admin user input their details the main DB opens with all access.

I have looked at the user permission/accounts etc that is already on Access but it doesnt work the way i want it!!!! can anyone help!!?! I'm a bit of novice compared to you guys so please make your replies idiot proof for me!

 

[lupins46]

Well based on what you say you want here, in my opinion Access security works in exactly the way you want.

You should read the Access security FAQ - it's not trivial nor a quick job- but the early part will spell out the steps you need to take.

http://support.microsoft.com/default.aspx?scid=kb;en-us;207793