Microsoft Access Translator

Page edited by Steven Hawkins


Changes (4)

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].

Full Content

Microsoft Access Translators

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 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.

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.

Stop watching space | Change email notification preferences
View Online | View Changes | Add Comment