Use vs to open access with a password

I played winform these two days and checked the access items,

 

The connection to the ACCESS database is similar to that of SQL.

 

 

Just pay attention to the format

 

String strcon = @ "provider = Microsoft. Jet. oledb.4.0; Data Source = D: // mydatabase. mdb; Jet oledb: Database Password = 123456 ";
Oledbconnection oldb = new oledbconnection (strcon );
Try
{
Oldb. open ();
MessageBox. Show ("OK! ");
}
Catch (exception ex)
{
MessageBox. Show ("No OK! "+ Ex. Message );
}

 

When the result is successfully opened, remember that data source should be written separately. The SQL connections are a little different, and the database password should also be noted.