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 <robert@xxxxxxxxxxxxxx> 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 <robert@xxxxxxxxxxxxxx> 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
|
