Microsoft KB Archive/209225

= ACC2000: Make-Table Query Does Not Copy All Table Properties =

Article ID: 209225

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209225



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you run a make-table query to create a new table, the table does not inherit all the properties from the table on which the query is based.



CAUSE
When you run a make-table query, the new table inherits only the Data Type and FieldSize property of each field in the query's underlying table, but not the other field or table properties.



RESOLUTION
To create a table that has the same properties as another table, use the Copy and Paste commands.

To use the Copy and Paste commands, follow these steps:


 * 1) In the Database window, select the table that you want to copy.
 * 2) On the Edit menu, click Copy.
 * 3) On the Edit menu, click Paste.
 * 4) In the Table Name box, type a name for the new table.
 * 5) Under Paste Options, select either the Structure Only or the Structure And Data option, and then click OK.



Steps to Reproduce Behavior
  Open the sample database Northwind.mdb, and create the following query based on the Categories table:   Query: Copy Category Table --  Type: Select Field: CategoryID Field: CategoryName Field: Description Field: Picture  On the Query menu, click Make Table Query, and then in the Table Name box, type Categories (MkTbl). Click OK. Save the query as Copy Category Table. Run the Copy Category Table query. View the Categories table in Design view. Note that fields have text specified for their Description property and have values specified for other field properties.</li> View the Categories (MkTbl) table in Design view. Note that the text specified for the Description property and the values specified for other field properties in the Categories table were not inherited by this table.</li></ol>

<div class="references_section">