Microsoft KB Archive/121564

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

= 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.