devxlogo

Opening a Password Protected Access Database

Opening a Password Protected Access Database

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.

See also  11 Effective Keyword Research Tools and Techniques
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist