XL98: "Value Out of Range" Error Running Parameter Query in Microsoft Query (179700)

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: 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 <data source name>" on the File menu, where <data source name is the name of your data source.
5. Type TEXT in the Type box, and then close the Info for <data source name> window.
6. Click Yes when you are prompted to save the changes.
7. On the File menu, click Quit.

Editing the DSN File in SimpleText

These steps specify that you should use SimpleText, which is normally installed with the Macintosh System Software. However, you can use any text editor when you follow these steps:

1. Start SimpleText.
2. 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
   						

3. Add the following line at the end of the [ODBC] section:

   Workarounds=524288

4. On the File Menu, click Save.
5. Click Quit to quit SimpleText.

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 <data source name>" 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."
5. Type odbc in the Creator box.
6. Close the Info for <data source name> window, and click Yes when you are prompted to save the changes.
7. 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:

1. Start SimpleText.
2. 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.
3. Locate the section that contains the information pertaining to your data source. Add the following line at the end of the section:

   Workarounds=524288

4. On the File Menu, click Save.
5. Click Quit to quit SimpleText.

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