Solved: Automatically cancel a password prompt

[Hexmath]

Version: Access 2003

Background: I wrote a VBA program in Access 2003 that opens Access databases and retrieves the format versions and stores them in a table.

Problem: When I run the program I have to babysit it because it will open an Access database that is password protected and the password prompt will appear and the program will stop until I press cancel.

What I need: code to automatically press cancel on the password prompt.

Code I use to open the databases:

oApp.OpenCurrentDatabase RSLT :help

[Hexmath]

Solved.

[geekgirlau]

Can you tell us what you did to resolve this issue? It could be of use to someone else in the future!

[Hexmath]

I changed the Wait argument to false. Thus the command will execute after the database opens. :kiss