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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Thomas HeikkilaHead of Information TechnologyAuthor Commented:
Thanks for the information.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.