Question:
I am developing an application in VB 4.0 connecting to an Access 7.0Database. I do not want to set up database security with groups, users andpasswords. All I want to do is set up a database password. Once I dothis, however, I can’t connect to the database. Help!
Answer:
The way to open a password protected Access database is by adding the PWDargument to the OpenDatabase command, as shown here:
Set db = OpenDatabase(“C:MyDB.mdb”, False, True, “;PWD=mypassword”)You have to follow the format exactly or Access will ignore the password.You have to have the semicolonexactly where it is in this example.