ACC97: SETUP: Microsoft Access 97 Does Not Install INSTCAT.SQL

• Microsoft Access 97

SYMPTOMS

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

The Setup program for Microsoft Access 97 and Microsoft Office 97, Professional Edition 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 versions of SQL Server earlier than version 6.5.

CAUSE

The functionality provided in the INSTCAT.SQL file is integrated into SQL Server version 6.5 and later.

RESOLUTION

If you are running a version of Microsoft SQL Server earlier than version 6.5, and you plan to use the SQL Server driver included on the Microsoft Office 97, Professional Edition or Microsoft Access 97 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 \OS\System folder.

MORE INFORMATION

To properly configure versions of SQL Server earlier than 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, 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.

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

Q100467 ACC: How To Determine Version of INSTCAT.SQL File on Server

Q95061 ACC: "Stored Procedure 'PROCEDURE' Not Found" Error Message

Keywords          : kbsetup 
Version           : 97
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: April 21, 1999