View Single Post
Old July 28th, 2006, 05:49 PM
kritimehrotra kritimehrotra is offline
Authorized User
Join Date: Jun 2006
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default Startup Options/Database Password


I have a database with certain startup options for the end user. What I would like is for the database to prompt for a password ONLY IF the shift key is used to try and bypass the startup options, so that only an authorized person with the password can see the background of the database. If I simply set a database password from the Tools menu, it asks for that password with the startup options as well, and I actually locked myself out of a database that way! So there needs to be some kind of check for whether or not the user attempted to bypass the startup options, and based on that, ask for a password or not. I am not sure if I can do this through Access options directly, or I will require some coding, but either method is fine.

Please help!

Thank you,