What is the connection string to access a MS Access database?

All languages ​​from Microsoft, and Web WUI (ie ASP, ASP.NET, Visual Basic 6, VB.NET and others) using the ODBC or OLEDB provider and use a different connection string for access to MS Access.

The following are the connection strings to Access using, respectively, the ODBC and OLEDB:

 



 Driver = {Microsoft Access Driver (*. mdb)}; dbq = db.mdb;

 

 



 Provider = Microsoft.Jet.OLEDB.4.0; Data Source = db.mdb;

 

Both strings, of course, require customization as necessary to properly insert the name and path of your MS Access DB.
Sometimes you may need to add username and password:

 



 Driver = {Microsoft Access Driver (*. mdb)}; dbq = db.mdb; Uid = X, Y = Pwd;

 

 



 Provider = Microsoft.Jet.OLEDB.4.0; Data Source = db.mdb; User Id = X, password = Y;