VBA 3031 Error (Not a Valid Password)

G

Guest

Eight statewide offices all run same version of the Access 2000 application.
Passwords are present for all and passed through VBA. Five of the eight
databases open no problem, the remaining three err out with error 3031 "Not a
valid Passsword". When I try to open manually any DB from the remaining three
that erred out using the same password that is in the code, it opens.

In summary if the password works manually and with 5 of the 8 db's using VBA
why does it blow up with the other 3 db's using VBA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top