Needed - JDBC Derby or ODBC-JDBC bridge

[likesAccess]

Hello Good People,

I would like to use Access (2003) as a front end for a Java DB I am working on in a separate java project. These speed and ease of using Access would be a godsend.



I would be extremely grateful if anyone could point me in the right direction.

So far I found one commercial ODBC-JDBC bridge that failed to run on 64 bit Win 7. Other interfaces I tried either didn't work, were just stupidly hard to set up, or didn't provide the functionality you get with Access.

Hopefully I am overlooking something easy.

Any tips, clues, or links to a driver or method to get Access connected to a jdbc DB would be extremely appreciated.

Thank you.

[likesAccess]

One thing I just discovered is that I can copy & paste an entire table of data (including Kanji) from Access to Java Derby (in Netbeans)

I am still looking for an ODBC-JDBC Driver to allow me to hookup Access (or SQL Server) directly to JDBC though.