Copy Table Properties on Make-Table Query

[Barbacuca]

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.

 

[DCrake]

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.