ACC: Make-Table Query Does Not Copy All Table Properties
ID: Q104487
|
The information in this article applies to:
-
Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
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:
- In the Database window, select the table you want to copy.
- On the Edit menu, click Copy.
- On the Edit menu, click Paste.
- In the Table Name box, type a name for the new table.
- Under Paste Options, select either the Structure Only or the Structure
And Data option button, and then click OK.
STATUS
This behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x
and 2.0), and create the following query based on the Categories table:
Query: Copy Category Table
--------------------------
Type: Select
Field: CategoryID
Field: CategoryName
Field: Description
Field: Picture
NOTE: In versions 1.x and 2.0, there is a space in the Category ID
and Category Name field names.
- On the Query menu, click Make Table, 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.
- 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.
REFERENCES
For more information about make table queries, search the Help Index
for "make table queries," or ask the Microsoft Access 97 Office
Assistant.
Additional query words:
maketable
Keywords : kbusage QryMktbl
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbprb