Connect to a Password protected Access database using Data Link Dialog

H

Homa

Hi,
I'm using a Data Link Dialog (*.udl) to setup a connection to a
password protected Access file.

The Access file is protected at the share level so in order to connect
to it sucessfully, I need to omit the UserID field in the connection
string. But for the udl file (and VS.NET Server Connection too), I
can't find the way to control this, it default to have UserID field
added.

Is there a work around for this?

Thanks for concern,
Homa Wong
 
B

Brendan Reynolds \(MVP\)

If you're not using JET user-and-group level security, leave the User Name
on the 'Connection' tab in the dialog box set to the default ('Admin') and
leave the 'Blank Password' text box checked - it applies only to the
user-and-group level password. On the 'All' tab in the dialog box, you'll
find a property called 'Jet OLEDB:Database Password'. This is the property
you need to set for the database password.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connection string, MOSS 2007 lists to Access w Pwd and Userid 2
Link to table from Protected Access Database 1
How to save ADP connection UserID/Password on exit. 1
Accessing Data on a password protected mdb from another mdb 1
Database Connection Password 1
Link a table to a password protected excel file? 0
Access cannot connect to any SQL databases 5
connect excel user form to access database 5

Top