Bypassing Initial Form when Opening Access Database

I have inherited the responsibility of an Access database that supports a production environment. When you open the database you are immediately taken to the main form. One option on that form is to exit to Access. When that option is selected, you are prompted for a password and if the correct password is entered, you have access to all tables, queries, forms, etc. I know how to change that password. Is there I way to open the database directly into the "design" view and if so, is there a way to prevent that?

I know there are many ways to secure an access database and I am not looking to make drastic changes right now.
Thomas HeikkilaHead of Information TechnologyAsked:
Who is Participating?
 
SimonCommented:
One way is to hold down the shift key when you open the Access database. This is sometimes disabled by setting a property named something like AllowByPassKey to FALSE, but you should try this on your database.

See these links for some ways to set/change the value of the bypass key boolean property

https://support.office.com/en-us/article/AllowBypassKey-Property-30ab5c36-51df-41a0-a955-b0f1deac517b
and
http://support.microsoft.com/kb/826765
0
 
Thomas HeikkilaHead of Information TechnologyAuthor Commented:
Thanks for the information.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.