Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

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.

 

 

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