I want to manipulate a Microsoft Access database (.accdb or .mdb file) from my Java project. I don&#39;t want to use the JDBC-ODBC Bridge and the Access ODBC driver from Microsoft because:

- the JDBC-ODBC Bridge has been removed from Java SE 8 and is not supported (ref: [here][1]),
- the JDBC-ODBC Bridge does not work properly with the Access ODBC driver when text includes Unicode characters with code points above U+00FF (ref: [here][3]), so such a setup would not be able to handle characters such as Greek, Russian, Chinese, Arabic, etc.,
- the Access ODBC driver from Microsoft only works in Windows, and 
- there are separate 32-bit and 64-bit versions of the Access Database Engine (and ODBC driver) which can be a nuisance for deployment.

I have seen other answers mentioning a JDBC driver for Access databases named [UCanAccess][4]. How can I set up my Java project to use this approach?

(Answers suggesting better ways of working with Access databases from Java would also be most welcome.)

[1]: http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html
[2]: http://en.wikipedia.org/wiki/Basic_Multilingual_Plane
[3]: https://stackoverflow.com/a/20982205/2144390
[4]: http://ucanaccess.sourceforge.net/site.html


All Ucanaccess Solutions on Gang of Coders

Total of 1 Ucanaccess Solutions

Manipulating an Access database from Java without ODBC