Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Cannot change the data type in a Parameter Query in Microsoft Query

Cannot change the data type in a Parameter Query in Microsoft Query

View products that this article applies to.

Symptoms

In Microsoft Excel, you try to change the data type in a Parameter Query in Microsoft Query. When you do this, the Data type list box is not available.

↑ Back to the top

Cause

This behavior is a design change in Microsoft Query. The Data type list box is unavailable (turned off) when the database driver supports the SQLDescribeParam command. This behavior does not occur when you use Microsoft Query with a Microsoft Access database.

↑ Back to the top

Keywords: KB831592, kbprb, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 831592
Revision : 4
Created on : 1/19/2007
Published on : 1/19/2007
Exists online : False
Views : 352