To Prevent a user bypassing the start-up options you will need to apply the following function and code to a command button (or ideally a hidden option,such as to the double-click event of a label or graphic).
This will prevent anyone without the password bypassing the start-up by using the Shift key.
The below function and command button code will allow you to use a password protected input box to determine if the Shift key can be disabled or not.
You might have to set your "References" in the VBA editor to DAO 3.6.
When you are viewing a Module, click the Tools menu » References. Browse for Microsoft DAO 3.6
Select "Files of type: Executable Files (*.exe; *.dll)"
C:\Program Files\Common Files\Microsoft Shared\DAO)
Then explicitly dimension yourcode, i.e. Dim db As DAO.Database, prp As DAO.Property
This will prevent anyone without the password bypassing the start-up by using the Shift key.
The below function and command button code will allow you to use a password protected input box to determine if the Shift key can be disabled or not.
You might have to set your "References" in the VBA editor to DAO 3.6.
When you are viewing a Module, click the Tools menu » References. Browse for Microsoft DAO 3.6
Select "Files of type: Executable Files (*.exe; *.dll)"
C:\Program Files\Common Files\Microsoft Shared\DAO)
Then explicitly dimension yourcode, i.e. Dim db As DAO.Database, prp As DAO.Property