Connecting to an Access database with a password 1

[rushdib]

Hi,
I am trying to connect to an Access database that opens with a password, and getting the following error message.

Microsoft Datalink error:
'Test Connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user.'

Any clue?

Thanks in advance,

Rushdi

 

[woyler]

how are you trying to connect?

 

[rushdib]

Using oleDBDataAdapter wizard, which uses the Microsoft Jet database driver.

 

[woyler]

what version of Access?
Which driver is it trying to use?

 

[rushdib]

I tried Access 2000 and Access 97.
I am using Microsoft Jet 4.0 OLEDB Provider from the list
Just now I tried after creating a workgroup information file, still can't connect.
I have no problem in connecting without the password in the Access database.

 

[woyler]

check the generated code and verify the connection string the wizard created.

 

[Zarcom]

Do you have an your own MDW file for the password?? If you do you need to include it in your connection string.

For Jet you use the following code
Jet OLEDB:System database=path and name of .mdw file here;

If you are using the designer when you set up the connection go to the all tab in the Data Link Properties dialog. You will see an entry for Jet OLEDB:System database. Edit the value to point to your .mdw file.

Hope this helps you. That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[rushdib]

Can you please tell me what is an .mdw file is? How do I create one?

Thanks,

 

[Zarcom]

It's Access's security file. You can overwrite it and create your own... how I am not sure. I was just given the database and told to use it. That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[rushdib]

I created the security file (.mdw) and changed the path on Jet OLEDB:System database=

Now I can't figure out how to connect the security file with the Access application. (storing the password in the security file)

 

[Schultjeff]

Is it just a generic password that opens the database, or is it a password that provides specific permissions to specific users?

If it is just an overall generic password, then you do not enter it on the second tab, the 'Connection' tab, of the connection wizard. Go to the 'All' tab of the wizard and enter it in the "Jet OLEDBatabase Password" property.

Jeff

 

[rushdib]

Thank you, that worked. It was a generic password.