Imagine your connection string for MS Access would look like this:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;"
Now to make the password interchangeable by code you rewrite it like so:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};User Id=admin;Password={1};
You can then do something like this in your code:
String connectionStringPattern = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};User Id=admin;Password={1};";
foreach(currentFileName in listOfAccessFileNames)
{
String connectionStringPatternWithFile = String.Format(connectionStringPattern, new String[] {currentFileName, "{0}");
String passWord1 = "firstPassword";
String passWord2 = "secondPassowrd";
String connectionString1 = String.Format(connectionStringPatternWithFile, passWord1);
String connectionString2 = String.Format(connectionStringPatternWithFile, passWord2);
}
Hope you get the idea!
— Manfred