asked on

ACCESSING PASSWORD PROTECTED DATABASES

Iam using MS Access 2000 as my backend, i have given database password.
But when i try to open using ADO Connection open , i am not able to
do so iam getting the following error:

Cannot start your application, the workgroup information file is
missing or opened exclusively by another user.

I have set only database password, no user accounts!!!
How to correct this ...Can any one give me the detailed coding ?

sudhi022299

Are you sure that your application is the only one that is accessing that file. If you have opened that file in Access, then close it and then run your program.

Regards,
Sudhi.

SiM99

I'm pretty sure that you can only use Access 97 databases with VB :|

Kamiro

Can you post your code where you are building the connection?

Have you set the specific Jet OLEDB Property called JetOLEDB:System Database?

ASKER CERTIFIED SOLUTION

MTroutwine

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

parthicaps

ASKER

Its working fine, is this possible to
write this coding in the following syntax :
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.path + "\databasename;Persist Security Info=False" ....

MTroutwine

Yes you can include it in the connection string as follows:
With cnnConnection
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\mydatabase.mdb; Jet OLEDB:Database Password=mydatabasepassword"
.Open
End With

:>)