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



microsoft access databases oledb