mdbtools-dev

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

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

[Andrew G. <aga...@ge...>]

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

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

[david w. <dav...@gm...>]

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