Accessing password-protected databases from .Net Framework

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Hello,
Any help would be much appreciated.
How can I open a password-protected mdb file from a C# application? What
should the connection string look like? I can open the database if it doesn't
have a password, but once I set a password (using Tools->Security->Set
Database Password) it doesn't work even when I include the password in the
connection string. It gives the error "Invalid user name or password".
It seems to me that the "User ID" and "Password" in the connection string
are the ones that should be used to open Access itself and are strored in the
workgroup information file, but it's not the DATABASE password. Where in the
connection string the database password can be included?
I am using Access 2002.

Thanks for your help.
 
On Wed, 8 Oct 2008 01:26:02 -0700, Andrew

I always refer to connectionstrings.com for these issues.

-Tom.
Microsoft Access MVP
 
Thank you Tom,
I checked out the website and found my answer there...
Much appreciated!!

Andrew
 
Back
Top