I have been trying to connect to an .mdb file protected by a password
created using Access 2003.
I fond some information on Microsof DAO Database:
The connect argument is expressed in two parts: the database type, followed
by a semicolon (

and the optional arguments. You must first provide the
database type, such as "ODBC;" or "FoxPro 2.5;". The optional arguments
follow in no particular order, separated by semicolons. One of the
parameters may be the password (if one is assigned). For example:
"FoxPro 2.5; pwd=mypassword"
My Code is:Set dbsC = OpenDatabase(Path + "\C.mdb",,,"ODBC;
pwd=mypassword")This will result in Run Time Error 3031: Not a valid
passwordHelp Anyone plz!