Hi, I've designed a database system that I recently put into use. It's used by about twenty people. Now, I have security features linking it to LDAP on the login screen to prevent people from accessing it, but if someone were to know that by holding shift they can bypass this startup page, then get into the options of the database and unhide the navigation pane and restore all menu buttons, they could start editting data in the back end tables.
So, what I'm wondering is, is there any way to fully lock down an Access (2007) database. This would only allow the user to view forms and reports. They cannot access anything else, nor can they get into an options menu to eliminate the protection. I have a seperate copy of the database (accdb) that I use for editing, and lock down when I replace the older one, so it's no issue for me if I cannot "Unlock" the database.
So, what I'm wondering is, is there any way to fully lock down an Access (2007) database. This would only allow the user to view forms and reports. They cannot access anything else, nor can they get into an options menu to eliminate the protection. I have a seperate copy of the database (accdb) that I use for editing, and lock down when I replace the older one, so it's no issue for me if I cannot "Unlock" the database.