Microsoft KB Archive/147192

= ACC: Where to Get Oracle and SQL Server ODBC Drivers =

Article ID: 147192

Article Last Modified on 8/17/2007

-

APPLIES TO


 * 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.



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.