I have a Microsoft Access 2002 database located on the Server: C:\AA\Vault\clients.mdb
Currently, all users have full access (add / change / delete / read / write / modify) to C:\AA\Vault\clients.mdb
Our new office policy wants to limit access as follows:
2 users (A and K) should be allowed to update (add / change / delete / read / write / modify) database records
3 users (C, J and S) should "only" be allowed to "read/search" database records
How would I go about setting permissions, to enforce the new policy?
Two thoughts come to mind:
Create two separate folders, one for updates and one for read only. Then have a scheduled task copy clients.mdb from the "updates" folder to the "read" only folder.
Create two database access groups in Active Directory, assign the 2 users to Update_Group, and assigned the 3 users to a "read_only group", then assign those permissions to the database: C:\AA\Vault\clients.mdb
However, I would prefer to check with you experts, who are more knowledgeable than myself.
Thanks for your help.