Home > FAQ > Database Linkage > Linking to Access

Linking to Access

If your data is in an Access accdb database you can link to this data by entering the following information into the ADO connection string box.

If your database has not been secured with a password:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessfile.accdb;Persist Security Info=False;

or, if the database is in your client folder:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=myAccessfile.accdb;Persist Security Info=False;

If your database has been secured with a password:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessfile.accdb;Jet OLEDB:Database Password=MyDbPassword;

or, if the database is in your client folder:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=myAccessfile.accdb;Jet OLEDB:Database Password=MyDbPassword;

If the database is not in your client folder, you will need to replace C:\myFolder\myAccessfile.accdb with the correct path and name of your Access file in either connection string.  If you enter a path and file name but the database is in your client folder, ProAdmin will automatically use a "relative path" internally and strip the path for display purposes. 

If you have secured your database with a password MyDbPassword will need to be replaced with the correct password for your database.