Hi,
Can somebody tell me what is the correct syntax to open a pasword protected access (.mdb) database using DBEngine.OpenDatabase method.
Thanks advance.
Printable View
Hi,
Can somebody tell me what is the correct syntax to open a pasword protected access (.mdb) database using DBEngine.OpenDatabase method.
Thanks advance.
dim dbName as Database
dim sdbLocation as String
' Assuming that your password is testpassword, the code will look as follows
sdbLocation = "C:\Test.mdb"
Set dbName = OpenDatabase(sdbLocation, False, False, ";pwd=" & "testpassword")
Sameer!!!