[ https://issues.jboss.org/browse/TEIID-3412?page=com.atlassian.jira.plugin... ] Kylin Soong edited comment on TEIID-3412 at 4/8/15 1:39 AM: ------------------------------------------------------------ I think we should do more estimation of the UCanAccess, does it really production ready? it more looks like a personal project, there only 12 discussions in sourceforge, I test with QA mdb, some table data can not be queried, but ODBC-JDBC bridge driver works fine. Below is one of errors which I met: ~~~ WARNING:Error in the metadata of the table EmpData: table's row count in the metadata is 52 but 51 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database. ~~~ this seems Row Count not synchronous between metadata and access file. UCanAccess not support MS Access 2013. I have found some issue related with MS Access 2013, so I think Teiid support MS 2013. If we decide to use UCanAccess, no so much work left, also not require a new translator, the work need to do is configure UCanAccess datasource in jboss server(it should be easy), the current access translator may works fine(probably a little adjustment). So do we will use UCanAccess? was (Author: kylin): I think we should do more estimation of the UCanAccess, does it really production ready? it more looks like a personal project, there only 12 discussions in sourceforge, I test with QA mdb, some table data can not be queried, but ODBC-JDBC bridge driver works fine. Below is one of errors which I met: ~~~ WARNING:Error in the metadata of the table EmpData: table's row count in the metadata is 52 but 51 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database. ~~~ this seems Row Count not synchronous between metadata and access file. UCanAccess not support MS Access 2013. I have found some issue related with MS Access 2013, so I think Teiid support MS 2013. If we decide to use UCanAccess, no so much work left, not require a new translator, the work need to do is configure UCanAccess datasource in jboss server(it should be easy), the current access translator may works fine with UCanAccess driver(probably a little adjustment). So do we will use UCanAccess? -- This message was sent by Atlassian JIRA (v6.3.11#6341)