Copy Table Properties on Make-Table Query

Barbacuca

New member
Local time
Today, 08:33
Joined
May 13, 2009
Messages
9
Hello,

According to the Microsoft Support website, 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.

However this info relates to Access 97 and older. I could not find any information on Access 2003.

QUESTION: How can one copy the original table properties to the resulting table from a "make-table" query?

Thanks for your help.
 
What you need to do is to copy the structure of the primary table and paste it to a new table then run an append query into the new table.
 

Users who are viewing this thread

Back
Top Bottom