Using Microsoft Access

Prerequisites

You have created a source system of the type OLE DB Agent.

The following procedure describes how you can establish the connection to a Microsoft Access database.

In the PCo Console, select an OLE DB source system.

The system displays the OLE DB connection tab.
Choose the Configure Connection String function key.

The Data Link Properties dialog box appears.

Select the appropriate entry on the Provider tab:

Data Source Used	Provider
Access (*.mdb)	Microsoft Jet 4.0 OLE DB Provider
Access 2007 (*.accdb)	Microsoft Office 12.0 Access Database Engine OLE DB Provider

Choose the Next >> pushbutton or the Connection tab.

The Connection tab appears.
Enter the directory where the database is located, such as C:\Users\D022222\Desktop\Test.mdb.
Enter the user name, such as Admin.
If you want to specify a password, you first need to select the Allow saving password checkbox.

If you want to work without a password, you need to select the Blank password checkbox.
Choose the Test Connection pushbutton to test the connection to the database.
Choose the Advanced tab to specify the access authorizations:

In the Access permissions area, select the Read entry so that users may read only.
On the All tab, check that False has been set for the Persist Security Info entry.
Choose the OK function key to adopt the settings.

The dialog box is closed.
Choose Save.