Tuesday, March 20, 2012

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

No comments:

Post a Comment