As far as I can tell, the file is not password protected. When I open it in
Access on a machine that it's never been opened on before, it doesn't ask for a
password and I can access the entire database.
I'll see if I can remember my SF user/pass in a bit and file a bug.
Jeff Smith wrote:
> 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 <agaffney@xxxxxxxxxx>
> To: mdbtools-dev@xxxxxxxxxxxxxxxxxxxxx
> 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
-------------------------------------------------------------------------
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/
|
