10

The JDBC-ODBC bridge is no longer supported with Java 8. Is there a way to access legacy MDB files without the bridge in Java 8? By legacy, I mean Access 2.0. Such old version is not supported by UCanAccess, which was suggested here.

Community
  • 1
  • 1
Andre
  • 3,874
  • 3
  • 35
  • 50

2 Answers2

3

Not sure what you're using the database for - but limited use might open up more options.

  1. Try mounting your database with Microsoft Access Database Engine 2010 Redistributable. Probably needs exclusive access to the database.

  2. Can you export the database to a flat file or import it into another JDBC-enabled database format? Either Access or another database format? Would require copying the database - probably only work for reporting or read-only access.

  3. Set up a sync process to mirror the database into something modern. Some in-memory Java type options: H2/Derby/SQLite. You may need to change your table structure to include last modified dates and manage those.

  4. Migrate the Access 2 database to SQL Server or another modern, multi-user database.

Including this info here, in case you are able to get to some intermediate version of Access. What won't work as-is:

Barett
  • 5,826
  • 6
  • 51
  • 55
  • thanks for the helpful info (hence my upvote ;). But I need to read and modify these old MDB files in-place. It's pretty stupid, I know... but some very old Brazilian government systems use these Access 2.0 MDBs and there's no way around it. – Andre Jun 16 '14 at 13:28
  • Jackcess did allow me to at least read some of these old files, which solved part of my problem. Cheers! – Andre Dec 21 '15 at 14:56
  • Great! I'm happy to help. – Barett Dec 22 '15 at 01:58
0

Sun's and Oracle's official positions have long been that --

the [JVM-bundled] JDBC-ODBC Bridge should be considered a transitional solution [...] Oracle does not support the JDBC-ODBC Bridge.

However, my employer, OpenLink Software, has produced enterprise-grade commercial Type 1 Bridges between JDBC and ODBC since Java 1.0, and these are fully compatible with the current Java 8 and any ODBC standard-compliant driver, including Microsoft's ODBC driver for Access. You can learn more here --

TallTed
  • 9,069
  • 2
  • 22
  • 37