Just modify your connection string as
string strFile = "D\\WORKS\\MyData.mdb";
string strPass ="MDBPassword";
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFile + ";Jet OLEDB:Database Password=" + strPass + ";";
change the variable
strFile and
strPass, and rest do as you do now.
cheers
Praveen.