Re: mdbtools doesn't like my Access database

Andrew,

This error is usually because the file is password-protected.  This is not supported.

If this is not the case, my recommendation is to create an entry in our bug database,
and attach a minimal file that exhibits the behavior.

You can just send me the file instead, but you would be taking a higher risk of it
falling through the cracks.  I don't have a lot of time right now for working on mdbtools.

 -- Jeff Smith


----- Original Message ----
From: Andrew Gaffney <[email protected]>
To: [email protected]
Sent: Tuesday, September 4, 2007 9:17:31 PM
Subject: [mdb-dev] mdbtools doesn't like my Access database

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







       
____________________________________________________________________________________
Sick sense of humor? Visit Yahoo! TV's 
Comedy with an Edge to see what's on, when. 
http://tv.yahoo.com/collections/222

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

_______________________________________________
mdbtools-dev mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev