Microsoft KB Archive/208740

= ACC2000: Microsoft Access 2000 Does Not Install INSTCAT.SQL =

Article ID: 208740

Article Last Modified on 8/9/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208740



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



SYMPTOMS
The Setup program for Microsoft Access 2000 and Microsoft Office 2000, does not install the SQL Script file, INSTCAT.SQL, to your hard disk. This file is used with the SQL Server ODBC driver to create stored procedures for use with Server version 6.5.



CAUSE
The functionality provided in the INSTCAT.SQL file is integrated into SQL Server version 7.0, but not in SQL Server version 6.5.



RESOLUTION
If you are running SQL Server version 6.5, and you plan to use the SQL Server driver included on the Access or Office compact disc, you must copy the INSTCAT.SQL file from the compact disc so that it is available for your application. The file is stored on the compact disc in the \System folder.



MORE INFORMATION
To properly configure SQL Server 6.5 for use with Microsoft ODBC, you must run the SQL script file, INSTCAT.SQL, to set up the proper stored procedures that provide catalog information used by Microsoft ODBC.

The INSTCAT.SQL script, when run on SQL Server 6.5, installs several stored procedures that are later used by the ODBC SQL Server driver to query the system catalog. Microsoft Access uses the SQL Server driver for ODBC access to SQL Server.

