JDBC-ODBC Bridge with MS Access 2000 & 97
Using jdbc-odbc bridge from JSDK 1.4.2 with MS Access 2000. Inserting records into db works for awhile but eventually I get an error which says that the db is in an unrecognized format. Sure enough I cannot even access the db via MS-Access - it gives the same error. If I save the original, empty db in MS Access 97 format before I do any inserts everything works OK and I never see the error. Could it be that the jdbc-odbc bridge has a problem with MS Access 2000 but not with 97?
Thanks,
Jim
Well, you cannot deny what's happening, so the answer may be yes, but only in a very round about way. JDBC does not explicity update the Access database. It sends requests to Microsoft's JET engine which then updates MS Access.
There should not be any difference between JDBC or ODBC making a request for an update through the JET engine. If JDBC calling the JET engine can corrupt the MS Access database then I would expect that the same problem could happen when using ODBC.
You may want to check your ODBC / JET versions on your computer and be sure they are up to date, and you may want to Google for corruption of MS Access 2000 database when using ODBC.
