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

VB Code:
  1. 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:
  1. Set dbsCanon _

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

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