Connecting to a password-protected Access DB via OLE

[Algernon83]

I need to create a program that one of the workers at my office can use to read and modify some columns of a table in an Access database. However, I can't figure out what connection string I would use to make this work. I specify all the details including the system database, but it leaves me with a "can't find installable ISAM" error, and I can't find any more useful information on this. Unfortunately, taking this out of Access is not an option. How can I make this work?

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<my database>;User ID=<userid>;Password=<password>;Jet OLEDB:System Database=<my system database>;Jet OLEDBassword=<database password>;Persist Security Info=False

 

[PHV]

Even with this ?
Jet OLEDB:[highlight]Database [/highlight]Password=<database password>;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Algernon83]

That's precisely what I needed. Thank you very much. What made this difficult was that I hadn't a clue where to find documentation on the connection string for this provider. Would you mind telling me how you found this out?

 

[cmmrfrds]

The easiest way to test out the connection is by using the UDL Wizard.

On your desktop create an empty text file.
Make sure this is a text file i.e. myudltest.txt

Then rename the text file to
myudltest.udl

The file should change to show a little computer icon.

Double click on the file.
Select the OLEDB provider for Jet4.0
Select your Access mdb as the file.
Go to the advanced tab and you will see all the settings.
Change to settings you want.
Press the test connection and when okay close the file.
Open the file with Notepad or Wordpad and you will see the connection string that you can paste into the App.