protect access 2007 FE with database password

[genesis]

I intend to put database password and encrypt the Front-End of access 2007.

Is there a way that I can open the front-end without the database password dialog box prompts to enter the password like using vba ?

 

[boblarson]

I intend to put database password and encrypt the Front-End of access 2007.

Is there a way that I can open the front-end without the database password dialog box prompts to enter the password like using vba ?

No, if you have put the database password on the frontend, the user would need to enter the password in order to use the frontend.

 

[genesis]

thanks for the reply Boblarson. Yes I agree that the use would need to supply the password. But can it be automated using VBA to automatically supply the password so that it will open normally without showing the password dialog box prompt? so that only the startup form will open?

 

[boblarson]

The answer again is NO - the password dialog is the very FIRST thing that will appear. There is no stopping it. If you use the database password, the very first item is the password dialog; period.

 

[Alisa]

Well, you could make them open it from a shortcut, and put a password switch in the shortcut. Then, as long as they used the shortcut, they wouldn't have to type in the password.