Microsoft KB Archive/179700

= XL98: "Value Out of Range" Error Running Parameter Query in Microsoft Query =

Article ID: 179700

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q179700



SYMPTOMS
When you enter a value in the Enter Parameter Value dialog box in Microsoft Query, you receive the following error message:

Numeric value out of range. Error in parameter 1.



CAUSE
This problem may occur if the following conditions are true:
 * You create a parameter query in Microsoft Query. -and-


 * You use the parameter query as criteria for a field that has a data type of Numeric or Float. -and-


 * You are using the Microsoft 3.01 dBASE PPC Open Database Connectivity (ODBC) driver to query for the data.



WORKAROUND
To work around this problem, use one of the following methods depending on whether you are using a File Data DSN or a User DSN.

Method 1: You Are Using a File DSN
If the name of the data source in the Data Source Name dialog box in Microsoft Query is not followed by an asterisk (*), you are using a File DSN to access the database.

This workaround requires using ResEdit. ResEdit is manufactured by Apple computer, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

ResEdit is available for download from the Apple World Wide Web site:

http://www.apple.com

The third-party contact information included in this article is provided to help you find the technical support you need. This contact information is subject to change without notice. Microsoft in no way guarantees the accuracy of this third-party contact information.

Changing the Creator Type
NOTE: Make a backup copy of your File DSN before you make the following modifications.

To use this method, first change the creator type. To do this, follow these steps:
 * 1) Start ResEdit. Click the startup screen.
 * 2) Open the File DSN for your data source. By default, File DSNs are stored in the System Folder:Preferences:ODBC File Data Sources folder.
 * 3) When you are prompted to add a resource fork to the file, click OK.
 * 4) Click "Get Info for " on the File menu, where  Start SimpleText.  Open the File DSN that you edited with ResEdit.

The file has a layout that is similar to the following:      [ODBC] DATABASE=Macintosh HD:Microsoft Office 98:Sample Files DRIVER={Microsoft 3.01 dBASE PPC}

[Microsoft Office] DefaultTable=CUSTOMER  Add the following line at the end of the [ODBC] section:

Workarounds=524288

 On the File Menu, click Save. Click Quit to quit SimpleText.</ol>

Restoring the File Type
Next, restore the file type. To do this, follow these steps:
 * 1) Start ResEdit.
 * 2) Open the File DSN.
 * 3) Click "Get Info for " on the File menu, where <data source name is the name of your data source.
 * 4) Type DSN in the Type box.

Note the blank space after the "N."
 * 1) Type odbc in the Creator box.
 * 2) Close the Info for window, and click Yes when you are prompted to save the changes.
 * 3) On the File menu, click Quit.

You can perform parameter queries in fields that contain numeric data.

Method 2: Are Using a User DSN
If the name of the data source in the Data Source Name dialog box in Microsoft Query is followed by an asterisk (*), you are using a User DSN to access your database.

The following steps specify using SimpleText, which is normally installed with the Macintosh System Software. However, you can use any text editor to perform these steps.

NOTE: Make a backup copy of your ODBC Preferences PPC file before you make the following modifications.

To use this method, follow these steps: <ol> Start SimpleText.</li> Open the "ODBC Preferences PPC" file. This file is located in the System Folder:Preferences folder.

The file contains a section titled [ODBC Data Sources], which lists all of your user data sources. Each user data source has its own section in the file.</li> Locate the section that contains the information pertaining to your data source. Add the following line at the end of the section:

Workarounds=524288

</li> On the File Menu, click Save.</li> Click Quit to quit SimpleText.</li></ol>

You can perform parameter queries in fields that contain numeric data.

<div class="status_section">

STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.

<div class="references_section">