Re: [mdb-dev] no data from jet 3 ?

[Rob <ro...@ir...>]

Thanks for the response!

I tried converting the database back to prior version through Access 2000, 
and get the same result as before; mdb-tables doesn't list anything for the 
converted db.  The Access2000 version of the database lists fine.

The App is Shooting Star http://www.foodogsoftware.com/ - an eBay auction 
management utility.  I'd rather not change this, as it does everything I 
need it to do, and I've got rather a lot of historical data stored in 
it.  I'm just trying to write a routine to track our ebay sales and tie 
them into our own web store ( http://www.russianglass.co.uk ).

If I give it the upconverted database, I get the error:
Error #3343 Unrecognized database format 'G:\blah\userdata.mdb'.
      Jet Version: 3.51
      Source: DAO.Workspace
      Help Topic 5003343 in jeterr35.hlp

It is quite happy, however, with having it's database password removed, and 
didn't seem to mind the db which had been converted up and back down again.

I presume that despite my having Access 2000 installed on this machine, 
it's using a lesser version runtime routines?  (It's much the same error if 
I try to open the later version db in Access 97.)

Thanks,

Rob


At 03:43 15/11/2004, Sam Moffatt wrote:

>In Access 2000, there is an option under the tools menu option to save
>it as an older version of the database, so you don't need access 97 to
>save databases in that format. Perhaps try using that. Also, what
>language is your windows app running? if you've got access 2000
>running, it shouldn't have any issues. and can you change the windows
>app?
>
>Sam
>
>
>On Mon, 15 Nov 2004 01:58:46 +0000, Rob <ro...@ir...> wrote:
> > Hi!
> >
> > I've been working on an ap in php, accessing an access database via odbc &
> > mdbtools.
> >
> > The database is actually from windows application, and appears to be using
> > the jet 3.51 engine for access.   As it was password protected (but I know
> > the password) I loaded it into Access 2000, converted to new format,
> > cleared the password, and saved it out as a temporary copy.  mdb tools
> > works fine on this copy, but I guess it's now in Jet 4 format.  The windows
> > app certainly objects to it anyway.
> >
> > I finally got around to installing office 97 on a pc so I could remove the
> > password from the database without converting the format.  This I managed
> > to do, and the windows app is happy with it, however mdb tools refuses to
> > return any data from it.  Even mdb-tables just prints a blank line and 
> exits.
> >
> > mdb-tables does however list the tables in Northwind.mdb samed from the
> > office 97 install.
> >
> > I'm using 0.6pre1, downloaded Nov 1st, running on FreebSD 4.10-STABLE #0.
> >
> > Is there anything else I can try, do, tell you, to solve this?
> >
> > Thanks,
> >
> > Rob.