Access database password (DAO)

[leinad31]

Without the database password, the software runs fine. I can access the database and the recordsets.

Set dbsCanon = OpenDatabase(App.Path & "\Data\CAICTBLS.dat")

But when I implemented a password in the access database (I opened it in access and set a password), my OpenDatabase statement says the password is invalid even though they are the same.

Set dbsCanon _
   = OpenDatabase(App.Path & "\Data\CAICTBLS.dat", , , "Microsoft Access database;pwd=canon")

I tried searching MSDN for a sample but couldn't find one.

[randem]

leinad31


Try Password=cannon

[Idephix]

You need to pass value for the 2 parameters that you skip.
This is due to a bug of DAO

[leinad31]

Oh so they aren't really optional? Okie, I'll try both suggestions later. Thanks.

[leinad31]

Had to tinker with the settings, but I was able to make it work like so;

Set dbsCanon = OpenDatabase(App.Path & "\Data\CAICTBLS.dat", False, False, ";pwd=canon")

Thanks for your help.