Database with password, opendatabase statement

[Niroth]

Hey,

So I'm trying to set a connection to a separate database with this statement


Dim dbs1 As Database

Set dbs1 = OpenDatabase("C:\database2.mdb", , False, ";pwd='abc'")


An error message keeps popping up saying "not a valid password", but I am 100% positive the password is correct. Is something wrong with my statement?

Niroth

 

[PeterF]

Did You try it without the single quotes around your password?

 

[Niroth]

Yep. Didn't work.

 

[DCrake]

This is a cut from one of my apps

   Set dbs = OpenDatabase(strDBPath, False, False, ";pwd=" & DBPass & "")

Where dbs, strDBPath and DBPass are all variables

David

 

[Niroth]

Thanks DCrake, that worked.