BW connectivity to Microsoft Access fails by error: "JDBC error reported: (SQLState = S1C00) - java.sql.SQLException

Business Works connectivity to Microsoft Access fails by error:
"JDBC error reported: (SQLState = S1C00) - java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented" at com.tibco.plugin.jdbc.JDBCActivity.eval

Solution:

BW officially does not support Access database .
The issue is because some JDBC APIs which are not supported in Sun's jdbc-odbc driver, i.e., Statement.setQueryTimeout() which is used in BW.
To solve/work-around this SQL Exception,use "bw.jdbc.timeout.useCancel=true" engine property. You can add this property in Bwengine.tra and try again. If you are running it from Designer, you need to create a file named Properties.cfg at \designer\ and add "bw.jdbc.timeout.useCancel=true" in it.