Connecting to Remote Access Databases

Connecting to remote Microsoft Access databases is supported for SQL SELECT statements only. You can remotely connect to Access 97, 2000, and 2003 databases; however, it is strongly recommended that you migrate to MSDE (Microsoft SQL Server Desktop Engine).

For additional Microsoft Access database information, refer to:, specifically, the Additional Best Practices for Network Environments and Opportunistic Locking (oplocks) on the Network File Server sections.

Before configuring and testing the connection, the Proficy Portal service must be set up with network file access rights so that it can access the remote database file.

To configure access rights on the Proficy Portal service

  1. Access the Administrative Tools/Services Windows control panel. Consult the Windows online help for specific instructions on how to access this control panel.

  2. Select the Proficy Portal service: InfoAgentSrv2

  3. As shown in the following, select the This account option, and enter the logon credentials for a Windows user with network access rights to your remote database file. This user must also have Administrator rights on the local server machine.

  1. Click OK.

To configure a remote Access database

  1. If you have not already done so, in the Proficy Portal client application, click the Administration button on the main toolbar. The Administration application appears.

  2. Click the Connectors & Data Sources button. A directory tree appears.

  3. Expand the folder for the data source you are configuring the remote Access database for. The associated window appears on the right.

  4. Select the jadoZoom (ADO Bridge) driver.

  5. In the Database URL box, enter the following:

jdbc:izmado:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\YourRemoteNode\..\YourDatabase.mdb

  1. Enter any other configuration information that is required.

  2. Click the Apply button to save the changes.

  3. Click the Test button to test the connection.