dotnetprogrammer
Programmer
I need to connect to a password protected MS Access database, using ADO. This is the open connection string I am using (nothing unusual):
myConnection.Open “c:\database.mdb”, "admin", "myadminpassword"
When I try to open the Access MDB file, VB generates error message as follows:
"Run time error ‘-2147467259 (80004005)’:
Can’t start your application. The workgroup information file is missing or opened exclusively by another user."
The database is on the local drive and hasn’t been not opened by anyone. If I remove the password from the databases it works just fine. But the problem is I must have the password protection. How can I connect to this database without using DSN or WRKGADM.EXE?
Your help will be greatly appreciated!
-fred
myConnection.Open “c:\database.mdb”, "admin", "myadminpassword"
When I try to open the Access MDB file, VB generates error message as follows:
"Run time error ‘-2147467259 (80004005)’:
Can’t start your application. The workgroup information file is missing or opened exclusively by another user."
The database is on the local drive and hasn’t been not opened by anyone. If I remove the password from the databases it works just fine. But the problem is I must have the password protection. How can I connect to this database without using DSN or WRKGADM.EXE?
Your help will be greatly appreciated!
-fred
