I am an admitted newbie to Access, and I could really use your help.
I am trying to create a database in Access to hold various information about a set of trials we are conducting. Due to government regulations (21 CFR Part 11), the database I use has to be "double" password protected. For me that means that not only does the database need to be password protected, but user-level access must also be password protected.
I know about setting the password for the database itself, but I am looking for good suggestions on how to go about setting up user level accounts with various Read/Write/Modify parameters as well. When I have tried to do this in the past, every database I launched from my machine had the same user login requirements, which leads me to believe that you were setting up accoutns for Access itself and not the single database as I had thought.
I am concerned that If I put the user account information into a table in the database, that it would be easy for someone to change their priveleges, even if I hide the tables view on startup (ctrl-Shift override).
I had thought of writing a small VB program to determine user access info from another database to control the main one, but I am unsure how to pass the permissions to allow from the VB program to Access once its launched.
The user level securities are applied to the database that they are set on. Once the correct MDA/MDW file is selected and the securities are set the database will not function without the correct password.
For an indepth tutorial re database securities see the knowledge base on microsoft.com.