KB147192 - ACC: Where to Get Oracle and SQL Server ODBC Drivers

Article ID: 147192

Article Last Modified on 8/17/2007

Microsoft Access 2.0 Standard Edition
Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

This article was previously published under Q147192

Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY

This article lists Microsoft SQL Server and ORACLE ODBC drivers that you can use with various versions of Microsoft Access and Microsoft Windows. In addition, the article lists the sources from which you can obtain the ODBC drivers.

MORE INFORMATION

Microsoft SQL Server

 MS Access   Client Operating   SQL Server     Sources of ODBC
  Version        System          Version           Driver
 --------------------------------------------------------------------------

   2.0       Windows 3.1          4.21a       MS Access 2.0 Upsizing Tools
             WFW 3.1                          16-bit ODBC 2.5 Drivers
             Windows 9x                       for the Win16 Client from
             Windows 2000                     the clients folder on the
                                              Microsoft SQL Server CD.

   2.0       Windows NT 3.51      4.21a       16-bit drivers (above) or
                                              32-bit ODBC driver from
                                              the ODBC folder on the
                                              Microsoft SQL Server CD.

   2.0       Windows 3.1          6.x         16-bit ODBC 2.5 Drivers
             WFW 3.1                          for the Win16 Client from
             Windows 9x                       the clients folder on the
             Windows 2000                     Microsoft SQL Server CD.

   7.0       Windows 9x           4.21a/6.x   Microsoft Access 7.0
             Windows NT 3.51/4.x              ODBC Drivers App note from
             Windows 2000                     the clients folder on the
                                              Microsoft SQL Server CD

   97        Windows 9x           4.21a/6.x   Microsoft Access 97
             Windows NT 3.51/4.x              Microsoft Data Access
             Windows 2000                     Components *
                                              The clients folder on the
                                              Microsoft SQL Server CD

   2000      Windows 9x           6.5/7.0     Microsoft Access 2000
             Windows NT 4.x                   Microsoft Data Access
             Windows 2000                     Components *

ORACLE

 MS Access   Client Operating   ORACLE         Sources of ODBC
  Version        System         Version            Driver
 --------------------------------------------------------------------------

    2.0      Windows 3.1         6.0 with      Microsoft Access 1.1
             WFW 3.1             SQL*Net 1.x   MS ODBC Drivers Pack 2.0
             Windows 9x                        ODBC Fulfillment Kit
             Windows NT 3.51
             Windows 2000
 
    2.0      Windows 3.1         7.0           ODBC Fulfillment Kit
             WFW 3.1             SQL Net 1.x
             Windows 9x
             Windows NT 3.51
             Windows 2000

    2.0      Windows 3.1         7.0 with      ODBC Fulfillment Kit
             WFW 3.1             SQL Net 2.x
             Windows 9x
             Windows NT 3.51
             Windows 2000

    7.0      Windows 9x          7.x           Microsoft ODBC Drivers
             Windows NT 3.51/4.x               Available in Microsoft
                                               Windows 2000
                                               Download Center

    97       Windows 9x          7.x           Microsoft Data Access
             Windows NT 3.51/4.x               Components *
             Windows 2000  

  2000       Windows 9x          7.x           Microsoft Data Access
             Windows NT 4.x                    Components *
             Windows 2000

* You can download the Latest Microsoft Data Access Components at the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e

Additional query words: inf latest drivers ODBC most recent

Keywords: kbfaq kbinfo kbusage KB147192