Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/104487

From BetaArchive Wiki

Article ID: 104487

Article Last Modified on 1/18/2007


  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition

This article was previously published under Q104487

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.


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.


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 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 button, and then click OK.


This behavior is by design.


Steps to Reproduce Behavior

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

  2. On the Query menu, click Make Table, and then in the Table Name box, type Categories (MkTbl). Click OK.
  3. Save the query as Copy Category Table.
  4. Run the Copy Category Table query.
  5. 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.
  6. 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.


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: kbprb kbusage KB104487