PSIfusion connection to MS Access DB

Problem

When you attempt to configure a data source lookup from PSIfusion to an MS Access DB file (*.mdb) you may receive the following error:

Error

An error occurred connecting to the data source:
The data provider failed to load the list of available tables/views

Solution

To resolve this, please check the permissions and formatting of the connection string, as they are most likely what is causing this issue.

Use the following connection string format:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[Adjust to database location];

In order for this to work you must have the proper permissions to the individual .mdb file. Right click on the .mdb file and go to properties. Click on Security and set permissions to Everyone[Full Control].


If you are still experiencing difficulties, please contact our Support team by: