Knowledge Base

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

Article ID: 192037

Article Last Modified on 3/7/2005

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.

MORE INFORMATION

Steps to Reproduce Behavior

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

Keywords: kbbug KB192037