Also see common JDBC Translator Information
The Microsoft Access Translator known by the type name access is for use with Microsoft Access 2003 or later via the JDBC-ODBC bridge.
If used in a dynamic vdb or the Teiid connection importer the importer defaults to importKeys=false and excludeTables=.*[.]MSys.* to avoid issues with the metadata provided by the JDBC ODBC bridge. You may need to adjust these values if you use a different JDBC driver.
The Microsoft Access Translator known by the type name ucanaccess is for use with Microsoft Access 2003 or later via the for the UCanAccess driver.