Connect to a Password protected Access database using Data Link Dialog

  • Thread starter Thread starter Homa
  • Start date Start date
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
 
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.
 
Back
Top