From: david w. <dav...@gm...> - 2007-09-19 12:11:36
|
On 05/09/2007, Andrew Gaffney <aga...@ge...> wrote: > 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 have very little experience with MS Access systems, but I once had to work with an application for a short while that had no security and mulitple users (things got messed up---I wonder why). I looked into what it would take to add some security to it and the whole MS Access security model looked like a nightmare to me. One way part of it seemed to work had something to do with being a member of a group and having a group permissions file or something. It didn't necessarily involve a password prompt. The details all got far too nasty for me to continue with it (I reimplemented it using php and mysql) but the point to this ramble is to ask if it is possible that it *is* protected/encrypted and the machines you are opening it on or the user you are opening it as have permission to open the db and therefore do not ask for an explicit password? Can you open it on a machine that has nothing to do with the place that it is installed? Dave > 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 > > ------------------------------------------------------------------------- > 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 > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > -- David Whiting |