Connect to a password protected MS Access DB

[Peter]

After I set the password for MS Access DB , i modify the connection string
from

connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=System.Environment.SystemDirectory\" & "MyDBName.MDB"

to

connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=System.Environment.SystemDirectory\" & "MyDBName.MDB" & ";User
Id=admin;Password= " & "MyPassWord" & ";"


Afterward I open the Access DB, it return error
"cannot start your application. the workgroup information file is missing or
opened exclusively by another user."

Any idea? thanks.

Peter

 

[Miha Markic [MVP C#]]

Hi Peter,

Try this string instead:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet
OLEDBatabase Password=MyDbPassword;"
(taken from www.connectionstrings.com)

 

[Peter]

It really works!!! thank you Miha.

Peter