/
MS Access Database

MS Access Database

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.

Related content

Database (old)
Database (old)
More like this
UCRex
More like this
Qualtrics to DB
Qualtrics to DB
More like this
MySQL (and Mariadb)
MySQL (and Mariadb)
More like this
HCP - Getting Data
More like this
Metrics - Import from Excel
Metrics - Import from Excel
More like this