Connect to Microsoft Access data sources (Connection String)

Applies to Infiniti v8.0 or later
 

Although not a recommended Microsoft Access can be used as an Infiniti Data Source.

The following OLEDB connection strings will work for access databases as per their version. Note the driver specified in the Provider attribute must be installed on the server.

Access 2003 (.mdb) Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp\accessDB.mdb;User Id=admin;Password=;
Access 2007+ (.accdb) Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;
 

Related Articles

 

Keywords

microsoft access databases oledb