MS Access with Java

[Doctor Cactus]

I am creating a Java application. Is there a simple way to read and write data to an MS Access database? All I have seen so far is stuff about JDBC/ODBC.

Help is much appreciated.

[masijade]

That's the one that is normally used.

Otherwise you can try Jackcess (Google for that), but AFAIK, that is not JDBC and is fairly limited. Otherwise Google for "Type 4 JDBC Driver MS Access". There is only one that I know (from HXTT I believe the company name is), but it is not free.

[Eku]

there are three ways to connect to MSAccess and i think the driver for that is already build in the JDK (i'll check on that) the name of the driver is JDBC-ODBC bridge.

3 ways to connect.
1. using ODBC with MS Access installed
2. using ODBC without MS Access installed
3. plain old direct connection to the file without any setting in the ODBC

About writing and saving data, it is much like SQL commands or you can use preparedstatement and just use batch processing. there are many ways ^_^ Just look for the one that suit your needs =)

[masijade]

Those are all simply JDBC-ODBC Bridge uses.

There are other ways. Check out Jackcess. And, like I said, there is also a Type 4 JDBC Driver for Access, although it is not free.

[Eku]

Thanks for the info masijade. i'll check that.