You are currently offline, waiting for your internet to reconnect

ACC: Where to Get Oracle and SQL Server ODBC Drivers

This article was previously published under Q147192
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
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:
inf latest drivers ODBC most recent
Properties

Article ID: 147192 - Last Review: 08/17/2007 02:54:28 - Revision: 5.3

  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
  • kbfaq kbinfo kbusage KB147192
Feedback