PRB: Field Properties Not Inherited with Make-Table Query
  
PSS ID Number: Q121564
Article last modified on 03-13-1995
 
1.00 1.10 2.00
 
WINDOWS
 

---------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Access versions 1.0, 1.1, and 2.0
---------------------------------------------------------------------
 
SYMPTOMS
========
 
You can use a make-table query to create a new table from a query's
dynaset. Although the new table will inherit the original table's data
types and FieldSize property settings, the new table will not inherit the
original table's Format, InputMask, Caption, DefaultValue, ValidationRule,
ValidationText, Required, or Indexed property settings.
 
CAUSE
=====
 
The new table only inherits the original table's data types and FieldSize
property settings. All other properties in the new table are set to default
values.
 
RESOLUTION
==========
 
After you run a make-table query, open the new table in Design view and re-
create the indexes and property settings. You may also want to define a
primary key for the table at this time.
 
STATUS
======
 
This behavior is by design.
 
MORE INFORMATION
================
 
Steps to Reproduce Behavior
---------------------------
 
1. Open the sample database NWIND.MDB.
 
2. Create a new query based on the Order Details table.
 
3. Drag all the fields from the Order Details field list to the query
   grid.
 
4. From the Query menu, choose Make Table.
 
5. In the Query Properties dialog box, type "Order Details Compare"
   (without quotation marks) in the Table Name box, and then choose
   the OK button.
 
6. Run the query.
 
7. Open the Order Details and the Order Details Compare tables in
   Design view. Compare the fields in the two tables and note that the
   Format property settings are missing in the Order Details Compare
   table.
 
REFERENCES
==========
 
Microsoft Access "User's Guide," version 1.0, Chapter 3, "Changing and
Customizing Tables," pages 39-42, and Chapter 7, "Designing Action Queries
and Parameter Queries," pages 163-167
 
Microsoft Access "User's Guide," version 1.1, Chapter 3, "Changing and
Customizing Tables," pages 39-42, and Chapter 7, "Designing Action Queries
and Parameter Queries," pages 167-171
 
Microsoft Access "User's Guide," version 2.0, Chapter 13, "Changing Data
with Action Queries," pages 301-303
 
Additional reference words: 1.00 1.10 2.00 maketable
KBCategory: kbusage
KBSubcategory: QryMaktbl
=============================================================================
Copyright Microsoft Corporation 1995.
