Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Enterprise, Visual Basic
Expertise: Beginner
Aug 6, 1997



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Opening Password-Protected Databases

Use the connect parameter of the OpenDatabase method to open a database that is password-protected in VB4-32. For example, this code opens the Secure database with a password of "dirt":

Dim wrk As Workspace
Dim dbTest As Database

Set wrk = DBEngine.Workspaces(0)

' Open Secure database with a 
' password of "dirt".
Set dbTest = wrk. _
        OpenDatabase("Secure.mdb", _
        False, False, ";PWD=dirt")

The connect parameter is case sensitive. In addition, and contrary to the VB documentation, you must set the exclusive and read-only parameters (the second and third parameters) when using the connect parameter.

Paul Litwin
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date