Connecting to password protected Accsses database

[Mladen]

Can someone tell me how can I connect to an Accsses 2000 database protected with password.It seems that I cannot write the ConnectionString wright.

[Mladen]

The error I get is:

"Cannot start your application. The workgroup information file is missing or opened exclusively by another user"

Can anyone help?

[marius]

Try to use a connection string similar with this:

 

Provider=MSDASQL.1;Password=password;Persist Security Info=True;Extended Properties="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\Test.mdb;

[Mladen]

That doesn't solve the problem.Does anyone have another solution?

[bigpeet]

enter ur Jet OLEDB:Database Password

 

when u r using access u need to set up ur "Jet OLEDB:Database Password" - this is not the first pass asked in the conn string.

 

i think that will fix it, make a new connection named conn1 and copy this:

 

only change ur_db_path ( ex : c:\temp\my.mdb)

and fill_in_ur_pass! (ex : gimmemoney)

 

everything that is in " - has to be in double "" - if u set up the parameters by string

 

 

conn1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=ur_db_path=Share Deny None;Extended Properties="""";" _

& "Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password=""fill_in_ur_pass!"";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1"

 

i hope that works peet

[Mladen]

peet, it works great.

Where are you,I want to buy you a drink?

I tried the exact same string only with the single quotes.

You saved me a lot of trouble

thanks

[bigpeet]

rep

 

glad if i could help u