Microsoft Access translators
Also see common JDBC Translators information.
- access
-
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 you are using the default native metadata import, or the Teiid connection importer, the importer defaults to
importKeys=false
andexcludeTables=.[.]MSys.
to avoid issues with the metadata provided by the JDBC ODBC bridge. You might need to adjust these values if you use a different JDBC driver. - ucanaccess
-
The Microsoft Access translator known by the type name ucanaccess is for use with Microsoft Access 2003 or later via the UCanAccess driver.