Microsoft KB Archive/192037

= BUG: Error Executing 'Make Table' Query on an Access Database =

Article ID: 192037

Article Last Modified on 3/7/2005

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition

-



This article was previously published under Q192037



SYMPTOMS
When using the Query Designer in Visual InterDev 6.0 to create a new table, the MAKE TABLE query returns the following error.

Microsoft][ODBC Microsoft Access 97 Driver] The query cannot be used as a row source

Although you receive the error above, the new table is created successfully in the Access database.



RESOLUTION
The error is not indicative of any real problems to have occurred and can be ignored.



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.



Steps to Reproduce Behavior

 * 1) Open a new Web project in Visual InterDev 6.0 and add a data connection to an Access Database.
 * 2) Double-click any table in the Data View that opens the Query Designer.
 * 3) In the Query Designer, change the type of query to "Make Table" using the Query Toolbar or by using the menu Query/Change Type.
 * 4) Enter a name for the new table.
 * 5) Run the Query.

Keywords: kbbug KB192037

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.