From: Andrew G. <aga...@ge...> - 2007-09-05 11:50:24
|
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 <aga...@ge...> > To: mdb...@li... > 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 |