ACC2002: Make-Table Dialog Box Does Not Accept Fully Qualified Three-Part Names (295227)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q295227
Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

The Make-Table dialog box does not allow you to add a fully qualified three-part name in the text box for the object name. If you enter a fully qualified three-part name, for example, master.dbo.customers, you receive the following error message:
Invalid Identifier master.dbo.customer
Access Help for the Make-Table dialog box states the following:

To create a destination table in another database, specify a fully qualified table name, including the name of the target database, the owner (if required), and the name of the table.

However, if you follow these directions, you still receive this error message.

RESOLUTION

You cannot add a fully qualified table name in the Make-Table dialog box. Instead, add a table name, and then manually modify the SQL statement to include the fully qualified table name. For an example of how to do so, follow these steps:
  1. Open the sample Access project NorthwindCS.adp.
  2. Create a new stored procedure and add the Customers table.
  3. Click the * in the field list of the table to add all the fields to the stored procedure.
  4. On the Query menu, click Make-Table Query.
  5. In the Make-Table dialog box, enter Customers.
  6. Click OK.
  7. On the View menu, point to Show Panes, and then click SQL.
  8. In the SQL pane, change the following line

    INTO dbo.customers

    to:

    INTO master.dbo.customers

  9. Save and then run the stored procedure.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

There are several places where Access Help encourages you to use the fully qualified table name; however, if you follow the instructions with a make-table query, you receive the error message that is mentioned in the "Symptoms" section of this article. The Access Help topics in question are:
  • "Create a Make-Table Query"
  • "Make-Table Dialog Box"

Steps to Reproduce the Behavior

  1. Open the sample Access project NorthwindCS.adp.
  2. Create a new stored procedure and add the Customers table.
  3. Click the * in the field list of the table to add all the fields to the stored procedure.
  4. On the Query menu, click Make-Table Query.
  5. In the Make-Table dialog box, enter master.dbo.customers.
  6. Click OK.
Note that you receive the error message that is mentioned in the "Symptoms" section of this article.
Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kbbug kbdocerr kberrmsg kbnofix KB295227
©2003 Microsoft Corporation. All rights reserved.