run time error 91 - - Computer Learning Zone

One truth I have discovered for sure: when you believe that all things are possible and you are willing to work hard to accomplish your goals, you can achieve the next "impossible" dream. No dream is too high!

-Buzz Aldrin

Home Courses TechHelp Help Contact Merch Join Order Logon Forums


	Back to Access Database Security Seminar Comments List

run time error 91

MUBEEZI M

13 years ago

Dear Puaar,

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

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Database Security Seminar.

Next Unseen