MS Access Database

Owned by Paul Macey (admin)
Last updated: Nov 05, 2014
1 min read

A Microsoft Access file can be used to link to the database.

Make sure connector is setup ok. The data are connected through a data source sidata64.

Update Linked Tables

Open the MS Access database

Go to the Tables view, right-click over the tables, select "linked Table Manager"

Click Select All, click OK, Close when finished

If you want to connect to another data source, you would select "Always prompt for new location"

Click Machine Data Source tab, select sidata64 (or sometimes sidata), click OK

You should be done; to check, open (double-click) a table and make sure you don't get an error (if you have loaded the database you should see entries in various tables, e.g., subjects).

Note: do not set the "BIGINT to INT" option in the connector; this setting is recommended for MS Access compatibility, but causes problems for CSPM, as the id/exam numbers are LONGINT's.