Access database password (DAO)

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

VB Code:

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.

VB Code:

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. :(

leinad31


Try Password=cannon

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

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

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

VB Code:

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

Thanks for your help.