opendatabase, with password

kennedymr2 · Apr 7, 2003

I am using an Access2000 database
I have given it a password admin

Set db = OpenDatabase("C:\abc\xyz.mdb", , , "PWD = admin&quot

This keeps coming up with invalid password

??Can you use the above where an Access2000 database in in use??

bros · Apr 7, 2003

are u set the password in database? if u didn't set it, u no need to declare password in open database.
"admin" is default. declare for others

kennedymr2 · Apr 7, 2003

Have tried various names. I think it must be something to do with access2000

VBOldTimer · Apr 8, 2003

Did you set up the password as a simple database password, or as a user password?
Are you sure admin is the password and not the user name?

kennedymr2 · Apr 8, 2003

Have worked it out
";pwd=admin&quot

Thanks for the replys