When I try and open Microsoft Access Database .MDB file under Access 2 DriverManager.getConnection("jdbc:Access:////mydir/XXXXXX.MDB") I get the message "failed to load database XXXXXX!" and SQLExeception.getNextException() gives the message "An invalid Access database page 0".
If I convert "XXXXXX.MDB" to for example "XXXXXX_2000.MDB" (Microsoft Access 2000 format) using the menu option Tools/Database Utilities/ Convert Database in Microsoft Access 2000 then try
DriverManager.getConnection("jdbc:Access:////mydir/XXXXXX_2000")
there is not a problem.
I am running the java program under unix but since it is pure java the OS should not be a problem
Hope someone can help
Thank-you
|
|
Access 2 is a very old mdb format. HXTT failed to find enough Access 2 samples and hasn't received support request for that version. What's your project?
|
The Issue has been resolved. The Access 2 mdb has been converted to Access 97 format at source and now the data loads OK.
Thanks!
|
Main
webmaster@hxtt.com