Microsoft Access Connection Strings

Standard:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

With Data Base Password:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbP@ssword;

Data Directory:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb;User Id=admin;Password=;

Network Location:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin;Password=;

You can change the provider to Access 2007-2010 Data Base:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

Please visit: www.TyroDeveloper
Please Click on +1