Java to MS Access Best practices

Wha开发者_StackOverflowt is the de facto standard method of getting a Java program (let's say its a Swing application) to communicate with a MS Access database?

Is this something the JDBC can handle? Apache POI?

Any others?

Need to be able to execute queries from the Java code and obtain the result sets (if applicable) for further processing.

Thanks!

You can either use JDBC-ODBC bridge or find and purchase a third party JDBC driver for MS Access.

A few years ago, when I tried using the JDBC-ODBC bridge to talk to Access it was horribly broken. There were third party drivers available that did a much better job. I just checked, and DataDirect (formerly Intersolv, formerly Merant I believe) doesn't list Access.

Today, I would start with the Jackcess library. Straight-forward, docs look good.