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.