Updating ODBC Drivers

[warpped]

I have a custom application that uses ODBC to connect to an Access 97 Database.

The application is running on 2 computers with NT 4.0 Workstation SP3. The computers do not have any Office products installed.

I just upgraded my development computer with Office 2000 Developers Edition, and I want to convert my Access 97 databases to 2000.

What are my options for upgrading the Access ODBC drivers on the 2 workstations without installing Office?

 

[Dreamboat]

Go here:

http://www.microsoft.com/technet/support/searchkb.asp

In the keywords, type in Q237994

Here's some of it:

MDAC Upgrade Issues With Access ODBC Driver

--------------------------------------------------------------------------------
The information in this article applies to:

Microsoft ODBC Driver for Access, version 4.0

--------------------------------------------------------------------------------


SUMMARY
Installing Microsoft Data Access Components (MDAC) 2.1 installs a new major version of the Microsoft Access ODBC driver. This new Access ODBC driver uses the Microsoft Jet 4.0 database engine which allows access to Microsoft Access 2000 format databases as well as all previous Microsoft Access database formats. The previous version of the Access ODBC driver that shipped with MDAC 1.5 and 2.0 used the Microsoft Jet 3.5 database engine to manipulate the Microsoft Access database file.

Due to design changes in Microsoft Jet 4.0 as well as backward compatibility issues in the new ODBC driver, installing the updated Access ODBC driver can break existing, installed ODBC applications that use the Access ODBC driver forcing the developer to re-code the application in some cases.



Hope it helps.


techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com