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


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
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

  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.
Modification Type:MinorLast Reviewed:3/7/2005
Keywords:kbBug KB192037
©2004 Microsoft Corporation. All rights reserved.