Will Jackcess work with MS Access 2013?

问题:

I am writing a Java application that creates some data for the user and needs to generate an Access file that the user can then download and open with MS Access. The user has MS Access 2013.

The only Java library I found online is Jackcess. However, in their documentation and in their API as well they only go up to V2010.

Will the file generated with File Format V2010 be opened by Access 2013? Based on research so far - no.

Are there any other solutions that will allow a Java program to create an Access 2013 file? Please, share! All help with Java + Access 2013 out there is for connecting to an Access 2013 database. I don't need to connect, I just need to create a file that the user will import.

回答1:

Yes, an Access_2010-format file (FileFormat.V2010) created by Jackcess can be opened in Access 2013. Jackcess can also manipulate an .accdb file created by Access 2013. I have done both of those tasks and they worked fine for me.

If you haven't done so already you might consider using UCanAccess. It uses Jackcess to do the actual reading and writing of the Access database file, but UCanAccess is a (pure Java) JDBC driver so you can use SQL instead of having to write directly to the Jackcess API. For more information, see

Manipulating an Access database from Java without ODBC