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

ID: Q192037

The information in this article applies to:

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.


Additional query words: 


Keywords          : kbVisDBTools kbVisID600bug kbGrpASP 
Version           : WINDOWS:6.0
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 24, 1999