Microsoft KB Archive/295227

= ACC2002: Make-Table Dialog Box Does Not Accept Fully Qualified Three-Part Names =

Article ID: 295227

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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:  Open the sample Access project NorthwindCS.adp. Create a new stored procedure and add the Customers table. Click the * in the field list of the table to add all the fields to the stored procedure. On the Query menu, click Make-Table Query. In the Make-Table dialog box, enter Customers. Click OK.</li> On the View menu, point to Show Panes, and then click SQL.</li> In the SQL pane, change the following line

INTO dbo.customers

to:

INTO master.dbo.customers

</li> Save and then run the stored procedure.</li></ol>

<div class="status_section">

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

<div class="moreinformation_section">

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 &quot;Symptoms&quot; section of this article. The Access Help topics in question are:
 * &quot;Create a Make-Table Query&quot;
 * &quot;Make-Table Dialog Box&quot;

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 &quot;Symptoms&quot; section of this article.

Additional query words: pra

Keywords: kberrmsg kbbug kbnofix kbdocerr KB295227

-

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

© Microsoft Corporation. All rights reserved.