PRB: Starting Analyzer Returns "Unknown Function Name"

Article ID: Q109940
Creation Date: 10-JAN-1994
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access versions 1.0 and 1.1

SYMPTONS

When you start the Database Analyzer in Microsoft Access version 1.x, you receive the error message "Unknown Function Name."

CAUSE

The line specifying the Database Analyzer library is missing or incorrect in the [Libraries] section of your MSACCESS.INI file. Some of the most common errors that cause this problem include:

You have multiple MSACCESS.INI files on your drive.
The Analyzer library line is missing from the [Libraries] section of the MSACCESS.INI file.
The equal sign (=) is missing from the Analyzer library line in the [Libraries] section of the MSACCESS.INI file.

RESOLUTION

There should be only one MSACCESS.INI file on your hard disk. It should be in your Windows directory. To check for multiple MSACCESS.INI files, follow these steps:

Start File Manager.
From the File menu, choose Search.
In the Search For box, type "MSACCESS.INI" (without quotation marks).
In the Start From box, type the letter of the drive that contains your Windows directory. For example, if your Windows directory is on drive C, type "C:\" (without quotation marks) in the Start From box.
Make sure the Search All Subdirectories checkbox is selected.
Choose the OK button.

A Search Results box will be displayed, showing the locations of all the MSACCESS.INI files on the drive you specified. Make sure there is only one copy of the file and that it is in your Windows directory. If there are other copies of the file, rename them or remove them.

Once you have verified that you have only one MSACCESS.INI file and that it is in the Windows directory, follow the steps below to check that the Analyzer library line in the MSACCESS.INI file is correct:

Open the MSACCESS.INI file in any text editor (such as Windows Notepad).
Locate the [Libraries] section of the file.
Modify the [Libraries] section so that it reads as follows:
[Libraries] analyzer.mda= wizard.mda=ro

Note that your [Libraries] section may have other lines than those shown here. The generic [Libraries] section here is for illustration purposes only. Also note the equal sign (=) at the end of the line. It is required; do not leave it off or remove it.

If your ANALYZER.MDA file is on a network drive, or in some directory on your local drive other than the ACCESS directory, make sure to include the full path to the ANALYZER.MDA file in the [Libraries] section. The sample [Libraries] section below demonstrates the appropriate Analyzer library line for an ANALYZER.MDA file located in the MDA directory on network drive F:

   [Libraries]
   F:\MDA\analyzer.mda=
   F:\MDA\wizard.mda=ro

STATUS

This problem no longer occurs in Microsoft Access version 2.0.

REFERENCES

For more information, refer to the PSSKB.TXT file in Microsoft Access version 1.0, or the ANALYZER.TXT file in Microsoft Access version 1.1. This file is located in your ACCESS directory.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.