OpenDatabase method ?

[raghu_nv]

Hi,
Can somebody tell me what is the correct syntax to open a pasword protected access (.mdb) database using DBEngine.OpenDatabase method.
Thanks advance.

[sameerd]

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!!!