How to password protect tables

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rnashting
    New Member
    • Mar 2010
    • 17

    How to password protect tables

    Good Afternoon! I have created a database in access 2007 with several forms. I set the navigation pane to not display, and a form to open on startup. I know that if you hit the shift key while opening the database it will display the database objects.

    What I am trying to do is make it so that if a user holds the shift key (so they can see/manipulate database objects) it prompts for a password first. Then if they don't have the password it just opens the form.

    Any suggestions would be much appreciated.
Working...