Access Table

[Guest]

Hi All,
I have set the password to my access db when i try to open from Visual Basic
gives an error not a valid password how do i solve this.

TIA

 

[Guest]

You can include the password in the open:

strDestinationMDB = "\\jo\SharedDocs\Access\ciscms.mdb"
Set dbf = DBEngine.OpenDatabase(strDestinationMDB, _
False, False, ";pwd=Frrito")

 

[Douglas J. Steele]

Just a reminder that while the 2nd and 3rd arguments are optional, you must
include them in the OpenDatabase call or it won't recognize the 4th
paramter.

 

[Guest]

I know, I just copied it from one of my testing tidbits in my bag of tricks.

 

[Guest]

thanks

I know, I just copied it from one of my testing tidbits in my bag of tricks.