| h1. *Microsoft Access Translator* (access) Translators* |
| |
| h3. 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. |
| {note} 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. {note} |
| h3. ucanaccess 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|http://ucanaccess.sourceforge.net/site.html]. |
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.