ODBC: How to install Access 2.0-Drivers when Access 2003 is installed

[StefanSerena]

Hi

I'm running Windows 2000 and Office 2003. I want to copy tables from an
unknown database format into Access 2.0 and I could do it quite easily
if it weren't for the fact that recent ODBC-drivers aren't capable of
writing into an Access 2.0 database (only reading). I do have the old
Access 2.0 disks including odbc-driver, but it doesn't install on my
machine (probably because the newer ones are installed...). And yes, I
know that updating the Access-database is probably the first thought
that everybody has, but it's not practicable in this case. So... how to
install Access 2.0-drivers when Access 2003 is installed?

Thank you!

Stefan Serena

[Linda Burnside]

You probably can't export it (although I hope somebody else can tell you
how to do it) directly into Access 2.0. How about exporting your data into
some other format that is readily importable into Access 2.0?

Linda

<St**********@g mail.com> wrote in message
news:11******** **************@ g44g2000cwa.goo glegroups.com.. .

Hi

I'm running Windows 2000 and Office 2003. I want to copy tables from an
unknown database format into Access 2.0 and I could do it quite easily
if it weren't for the fact that recent ODBC-drivers aren't capable of
writing into an Access 2.0 database (only reading). I do have the old
Access 2.0 disks including odbc-driver, but it doesn't install on my
machine (probably because the newer ones are installed...). And yes, I
know that updating the Access-database is probably the first thought
that everybody has, but it's not practicable in this case. So... how to
install Access 2.0-drivers when Access 2003 is installed?

Thank you!

Stefan Serena

[David W. Fenton]

St**********@gm ail.com wrote in
news:11******** **************@ g44g2000cwa.goo glegroups.com:

I'm running Windows 2000 and Office 2003. I want to copy tables
from an unknown database format into Access 2.0 and I could do it
quite easily if it weren't for the fact that recent ODBC-drivers
aren't capable of writing into an Access 2.0 database (only
reading). I do have the old Access 2.0 disks including
odbc-driver, but it doesn't install on my machine (probably
because the newer ones are installed...). And yes, I know that
updating the Access-database is probably the first thought that
everybody has, but it's not practicable in this case. So... how to
install Access 2.0-drivers when Access 2003 is installed?

There's absolutely nothing inherent in the later versions of Access
nor in recent versions of Windows that prohibits the installation of
Access 2.0. You just have to make sure you install it in a different
directory than your existing Office installation(s) . Of course,
that's made fairly easy by Access 2.0 being a Win3.x program, which
didn't have long filenames, and before Microsoft implemented the
standard C:\Program Files\ default programs folder.

I have Win2K, and have Access 2.0, Access 97 and Access 2002 (from
Office XP) installed. All work just fine.

What exactly happens when you try to install it? Are you running the
installer under a logon with full administrative permissions on the
machine you're attempting to install it on?

It's usually recommended that multiple versions of Access be
installed in release order, but I installed Access 2.0 on this
machine after installing the other versions of Access, and had no
problems at all.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[StefanSerena]

Thank you for your answers!
@Linda: Thank you for your answer. That would be the worst case
solution, yea... the thing is that the access-db has to be updated
twice every week by people that are not very familiar with computers...
so I wrote a perl-script that would do the job automatically, and
that's also why I'm dependent upon odbc.

@David: I could easily install Access 2.0 after 2003 was installed and
it works fine. But maybe I didn't make it clean enough that it's about
the corresponding ODBC-drivers. I still can't find them in the
'Microsoft ODBC-Administration' panel. As I wanna write into the Access
2.0 database via Perl, I need them.

Still hoping to get more help... thx!

Stefan

[david epsom dot com dot au]

Your gonna get 16 bit ODBC drivers - and 16 bit ODBC admin.
It is a separate program. I don't know how Perl will go
writing to 16 bit ODBC drivers, but I reckon you will need
to find a 16 bit data access object - I don't think you
are going to be able to do that using ADO.

If your current version of ADO or DAO is having trouble
writing to Jet 2.5 data (and I've never tried that),
then you need to specify the Jet 3.5 drivers.
(david)

<St**********@g mail.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

Thank you for your answers!
@Linda: Thank you for your answer. That would be the worst case
solution, yea... the thing is that the access-db has to be updated
twice every week by people that are not very familiar with computers...
so I wrote a perl-script that would do the job automatically, and
that's also why I'm dependent upon odbc.

@David: I could easily install Access 2.0 after 2003 was installed and
it works fine. But maybe I didn't make it clean enough that it's about
the corresponding ODBC-drivers. I still can't find them in the
'Microsoft ODBC-Administration' panel. As I wanna write into the Access
2.0 database via Perl, I need them.

Still hoping to get more help... thx!

Stefan