Experts:
Attached is a database with a login form. It goes w/o saying, until user enters valid credentials, no other Access objects (i.e., tables, queries, forms, etc.) should be accessed.
For demo purposes, please use the following login credentials for the attached demo db:
Username: John
Password: password
Once entered, the login form disappears and the user can proceed to access all Access objects... this works great!
HOWEVER, if any user presses/holds the SHIFT key prior to opening the db, the login form is bypassed and anyone could, e.g., enter the table object and then change the password. Naturally, this needs to be prevented!
Now, I have come across multiple postings that refer to "disabling the shift key" via adding a module that overwrites the "AllowBypassKey" property. In the attached example, I added a module as illustrated by the Microsoft support site (https://support.microsoft.com/en-us/...ss-database-pr). Still, when I press/hold the Shift key prior to opening the database, I still can get to the tables objects where anyone, again, could change the passwords.
What am I missing? How can I enforce this security level so that no one can get to the Access objects unless they enter a proper username/password (with or without holding down the Shift key)?
Thank you,
EEH