Try these two options; 1. Set db = ws.openDatabase(BE_DATABASE, False, False, "MS Access;pwd='" & BE_PASSWORD & '"") Notice the single quotes near the equal sign. This is because the BE_PASSWORD is a string and not a number.
2. When I open the backend, i normally just write like below and it works for me; Set db = OpenDatabase(BE_DATABASE, False, False, ";pwd=Hello!")
Good luck!
MICAH
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
