ACC2000: Microsoft Access 2000 Does Not Install INSTCAT.SQL

ID: Q208740

The information in this article applies to:

Microsoft Access 2000

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.

REFERENCES

For more information about the INSTCAT.SQL file, search for the keyword "Instcat.sql" in the Microsoft SQL Server Books Online. To obtain the SQL Server 7.0 Books Online, please visit the following Microsoft Web site:

http://support.microsoft.com/download/support/mslfiles/sqlbol.exe

For additional information about using the INSTCAT.SQL file, please see the following article in the Microsoft Knowledge Base:

Q209523 How to Determine Version of INSTCAT.SQL File on Server

Additional query words:

Keywords : kbsetup kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb