Make Table Query - Properties?

  • Thread starter Thread starter John Keith
  • Start date Start date
J

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


Jeff Boyce said:
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
Click to expand...
 
Back
Top