Make Table Query - Properties?

[John Keith]

How do I set the properties of the table-fields when creating a table with a
make table query?

I already know how to:
1) use VBA and create the tabledef then fill in the table with query
results. or
2) manually enter the properties, never delete, only empty and fill the
table to refresh the data. or
3) Use a template table to copy as empty, then fill it.

I am trying to use the Access2003 program as the interface is designed
rather then "brute-force" controlling it with VBA.

 

[Jeff Boyce]

John

It sounds like you've come up with a reasonable set of options.

I tend to use the #2 approach -- it seems like this gives me better control
over the table definition (and doesn't require rebuilding the definition
each time I "load" it).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Keith]

I was hoping that there was an option to set on the MakeTable query that
would accomplish this.

However...
I found that I could do this with a 2-step macro:
Delete Query that empties out the table
Append Query that populates the table

This works well and keeps all the properties.


--
Regards,
John

John

It sounds like you've come up with a reasonable set of options.

I tend to use the #2 approach -- it seems like this gives me better control
over the table definition (and doesn't require rebuilding the definition
each time I "load" it).

Regards

Jeff Boyce
Microsoft Office/Access MVP