I'm trying to open a local MS-Access 97 Database, (path is same as application, but that doesn't matter anyway)
When I had not password-locked the db, all I need was
Set DB = OpenDatabase(DbaseName)
But now that I need the database to be more secured, I put in a password, but I don't know where to put it in the function call.
I think it's supposed to be in the connection string but I've tried the following, but it doesn't work, it says "Invalid Password".
Set DB = OpenDatabase(Dbasename, , , ,"Pwd=MyDbPassword")
Any help would be greatly appreciated.