Security - Read only except for 3 specific people

[malibu65k]

All,

I have a database that I need to make it where ANYONE can view a few reports and a couple of forms (Read Only) and only 3 people have rights to everything else like updating data and going to all areas of the database. What is the best way to do this?

Thanks!

 

[dhookom]

This depends on how bullet/idiot-proof you want to make your MDB. If you want the highest level of security, consider moving your data to SQL Server. If you want basic, hackable security you can grab the users' network login and use code to set forms to read-only.

Duane
Hook'D on Access
MS Access MVP

 

[JBinQLD]

G'day malibu,

There is the option of applying user level security too. We have a standard user account called "User" with no password which allows read only access. We have another account called "Input" and a simple password which only allows records to be entered, then we have "dev" which has a substantial password and allows full admin right to the database and all objects.

Backup your database before having a play with the user-level security wizard!

Good luck,

JB

 

[malibu65k]

Unfortunately, I work for the government and we are only allowed to use MS Access and our network system tries to make my job and the users' jobs difficult. They are soon out the door in the near future anyway, but in the meantime I have been tasked with letting everyone and anyone who has access to this share drive to access a read only (just a couple of forms and a few reports only) version. I was thinking maybe a separate database with forms and reports with no password and just link the necessary tables to this db.(a Front end only). Will this work if the main db has a password?