mdbtools-dev

[mdb-dev] no data from jet 3 ?

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

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.

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

[Sam M. <pa...@gm...>]

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.
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>

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.

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

[Sam M. <pa...@gm...>]

Well, perhaps the best option is to write a macro/com automation to
get access to convert the database to the right format. I've done a
bit of work with Word automation (using PHP mostly), perhaps you could
also something similar to automate the process.

If your trying to link it in, perhaps run the script automatically
every hour. Its the best solution. You'll need a dedicated windows
box, but since access will be doing the work, it should be right.
There is some issues and microsoft doesn't support using office in
this way, have a look on msdn about it, but it can be done.

access is a pain in the ass to use, but for a lot of things, its a
fact of life. if your familiar enough with php (my favourite
language), it appears to work alright with office, just use the vba
help (functions are the same, so it doesn't matter).

Good luck,

Sam


On Mon, 15 Nov 2004 06:08:42 +0000, Rob <ro...@ir...> wrote:
> 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.
> 
>

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

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

Sam.

Some sort of automated scripting to do the conversion was what I was 
thinking about also..  I'll keep playing.  Many thanks for the help.

Rob


At 08:02 15/11/2004, Sam Moffatt wrote:

>Well, perhaps the best option is to write a macro/com automation to
>get access to convert the database to the right format. I've done a
>bit of work with Word automation (using PHP mostly), perhaps you could
>also something similar to automate the process.
>
>If your trying to link it in, perhaps run the script automatically
>every hour. Its the best solution. You'll need a dedicated windows
>box, but since access will be doing the work, it should be right.
>There is some issues and microsoft doesn't support using office in
>this way, have a look on msdn about it, but it can be done.
>
>access is a pain in the ass to use, but for a lot of things, its a
>fact of life. if your familiar enough with php (my favourite
>language), it appears to work alright with office, just use the vba
>help (functions are the same, so it doesn't matter).
>
>Good luck,
>
>Sam
>
>
>On Mon, 15 Nov 2004 06:08:42 +0000, Rob <ro...@ir...> wrote:
> > 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.
> >
> >
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: InterSystems CACHE
>FREE OODBMS DOWNLOAD - A multidimensional database that combines
>robust object and relational technologies, making it a perfect match
>for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>_______________________________________________
>mdbtools-dev mailing list
>mdb...@li...
>https://lists.sourceforge.net/lists/listinfo/mdbtools-dev