From: Andrew G. <aga...@ge...> - 2007-09-05 02:17:49
|
I've got an Access 97 format database that's being used with a cash register application (Micro Register). For some reason, mdbtools doesn't recognize it as a valid Access database. I've tried upgrading it to Access 2000 and 2002, as well as doing "Compact & Repair". Here's what I get when I try to play around with it: mal ~ # mdb-ver /tmp/microreg.mdb JET3 mal ~ # mdb-schema /tmp/microreg.mdb File does not appear to be an Access database mal ~ # mdb-schema -S /tmp/microreg.mdb File does not appear to be an Access database Now, if I export one table from this database into a blank Access 2000 database, the new file can be read just fine by mdbtools. I tried just removing all the tables except the one I exported from the original (thinking it was one of the other tables that was causing problems), but mdbtools didn't like that, either. I'd just do the one-time export and use that, but I need "real-time" synchronization between this Access database and an e-commerce site I'm putting together for the business that runs this cash register application. I've looked into other solutions such as using an ODBC network gateway, but I can't find anything that would work with perl or PHP in linux If it helps, both 0.5 and 0.6_pre1 would segfault if I ran 'mdb-schema -S' on the file, but a more recent CVS checkout (output above) fails a bit more gracefully. I can also post a version of the database with just the single table I'm interested in but that still fails with mdbtools. I assume anything done to make mdbtools work with that database would also work with the original. Thanks for any help that anyone can provide. -- Andrew Gaffney http://dev.gentoo.org/~agaffney/ Gentoo Linux Developer Catalyst/Installer + x86 release coordinator |