Re: [mdb-dev] mdbtools doesn't like my Access database

[Jeff S. <why...@ya...>]

Andrew,=0A=0AThis error is usually because the file is password-protected. =
 This is not supported.=0A=0AIf this is not the case, my recommendation is =
to create an entry in our bug database,=0Aand attach a minimal file that ex=
hibits the behavior.=0A=0AYou can just send me the file instead, but you wo=
uld be taking a higher risk of it=0Afalling through the cracks.  I don't ha=
ve a lot of time right now for working on mdbtools.=0A=0A -- Jeff Smith=0A=
=0A=0A----- Original Message ----=0AFrom: Andrew Gaffney <agaffney@gentoo.o=
rg>=0ATo: mdb...@li...=0ASent: Tuesday, September 4, =
2007 9:17:31 PM=0ASubject: [mdb-dev] mdbtools doesn't like my Access databa=
se=0A=0AI've got an Access 97 format database that's being used with a cash=
 register =0Aapplication (Micro Register). For some reason, mdbtools doesn'=
t recognize it as =0Aa valid Access database. I've tried upgrading it to Ac=
cess 2000 and 2002, as =0Awell as doing "Compact & Repair". Here's what I g=
et when I try to play around =0Awith it:=0A=0Amal ~ # mdb-ver /tmp/microreg=
.mdb=0AJET3=0Amal ~ # mdb-schema /tmp/microreg.mdb=0AFile does not appear t=
o be an Access database=0Amal ~ # mdb-schema -S /tmp/microreg.mdb=0AFile do=
es not appear to be an Access database=0A=0ANow, if I export one table from=
 this database into a blank Access 2000 database, =0Athe new file can be re=
ad just fine by mdbtools. I tried just removing all the =0Atables except th=
e one I exported from the original (thinking it was one of the =0Aother tab=
les that was causing problems), but mdbtools didn't like that, either.=0A=
=0AI'd just do the one-time export and use that, but I need "real-time" =0A=
synchronization between this Access database and an e-commerce site I'm put=
ting =0Atogether for the business that runs this cash register application.=
 I've looked =0Ainto other solutions such as using an ODBC network gateway,=
 but I can't find =0Aanything that would work with perl or PHP in linux=0A=
=0AIf it helps, both 0.5 and 0.6_pre1 would segfault if I ran 'mdb-schema -=
S' on =0Athe file, but a more recent CVS checkout (output above) fails a bi=
t more =0Agracefully. I can also post a version of the database with just t=
he single table =0AI'm interested in but that still fails with mdbtools. I =
assume anything done to =0Amake mdbtools work with that database would also=
 work with the original.=0A=0AThanks for any help that anyone can provide.=
=0A=0A-- =0AAndrew Gaffney                                 http://dev.gento=
o.org/~agaffney/=0AGentoo Linux Developer             Catalyst/Installer + =
x86 release coordinator=0A=0A=0A=0A=0A=0A=0A=0A       =0A__________________=
__________________________________________________________________=0ASick s=
ense of humor? Visit Yahoo! TV's =0AComedy with an Edge to see what's on, w=
hen. =0Ahttp://tv.yahoo.com/collections/222