Automatically supply database password in a macro or VBA code

[Guest]

I have a macro set up in my access database which runs a complex MakeTable
query that takes about 30 min or more to run, so it cannot conveniently run
during the day when other people are using the database.

The problem is that this database is password-protected by the set password
feature in access. How can I supply the *database* password automatically so
this macro can be run after hours?.

 

[Guest]

Hi Andi,

If you are not talking about user-level security, but rather a simple
database password, then try this KB article:

How to open a password-protected database through Automation
http://support.microsoft.com/?id=235422

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a macro set up in my access database which runs a complex MakeTable
query that takes about 30 min or more to run, so it cannot conveniently run
during the day when other people are using the database.

The problem is that this database is password-protected by the set password
feature in access. How can I supply the *database* password automatically so
this macro can be run after hours?

 

[Guest]

Thanks! I'll try this.