Microsoft Access Tables

A table in a Microsoft Access database can be opened directly in a dataview. Use the OpenTable() function with a table type of ACCESS and a spec array of either two or three elements. The first element is the filename of the mdb database file and the second element is the name of a table in that database. The optional second item can specify the name of a field in the table which can be used as a key field, with unique values for identifying individual records in the table, thereby allowing values to be edited. For example:

view_name = OpenTable("Access Data", "ACCESS", { "c:\\my_db.mdb", "MyTable", "ID"})

Microsoft Access dataviews can be saved to a file for later re-opening.