
	Search KbAlertz Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account

Already have an account?
[Click here to Login]

Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Ads by Lake Quincy Media

Article ID: 209225 - Last Review: June 24, 2004 - Revision: 2.0

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

View products that this article applies to.

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.

Back to the top

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.

Back to the top

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

Back to the top

MORE INFORMATION

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

Back to the top

For more information about make-table queries, click Microsoft Access Help on the Help menu, type create a new table from the results of a query with a make-table query in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Back to the top

APPLIES TO

Microsoft Access 2000 Standard Edition

Back to the top

kbprb kbusage KB209225

Back to the top

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Ads by Lake Quincy Media