Quote Originally Posted by johnseito View Post
I see how you can disable the shift key so can’t go into tables and queries but how do you enable it for developers ?
You enable the shift bypass by reversing the code used to disable it

However, developers should normally only need to work on the ACCDB file therefore will only rarely, if ever, need to look at tables & queries in the ACCDE file

My suggestion would be as follows:

Assign permission levels for standard users & developers.
This means people will need to login to your database with user name & password
The user level will then be detected at login

Add code to check the file type ACCDB or ACCDE.
a) If ACCDB, enable shift bypass.
b) If ACCDE, disable shift bypass for standard users but enable it for developers

NOTE The database will need to be closed, reopened & closed again before the shift bypass code will be fully implemented

Good luck