Access to Microsoft Access

To access data from a Microsoft Access database, you can link or import the data. The data in a linked table is refreshed when the table is accessed and whenever the time since the last refresh exceeds the table's Cache Interval setting.

Imported data is loaded into the PI AF table once. If you ever need to refresh the imported data in a table, you can right-click the table in the Library browser and click Re-Import Table.

You can link to or import data from a Microsoft Access table after you perform the following steps:

• Specify the source database.

• Create a query that returns the desired data.

• Enter any login credentials required to access the database.

  The exact instructions depend on your hardware configuration and what you are trying to do:

  32-bit PI AF server	Follow the instructions in Link or import data.
  64-bit PI AF server	To import, follow the instructions in Link or import data. To link, follow the instructions in Link to data on a 64-bit PI AF server.