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
<(E-Mail Removed)> wrote:

I always refer to connectionstrings.com for these issues.

-Tom.
Microsoft Access MVP


>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.

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

Andrew

"Tom van Stiphout" wrote:

> On Wed, 8 Oct 2008 01:26:02 -0700, Andrew
> <(E-Mail Removed)> wrote:
>
> I always refer to connectionstrings.com for these issues.
>
> -Tom.
> Microsoft Access MVP
>
>
> >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.
>