Importing lookiup tables at startup

I am looking to import some lookup tables at startup to
speed up the database. I am using make table queries which
work fine except for one problem. The new tables are
created with the subdatasheet name set to auto which
really slows things down. Is there a way to go in and set
this value to none or is there a better way to accomplish
this task than to use make table queries? Thanks for any
help.

Alan

I suppose another approach would be to create your local lookup tables one
time, and thereafter, use a pair of queries to first delete everything from
a lookup table, then "reload" it from a linked table.

If you are using the term "lookup" table to mean small tables of
commonly-used values (e.g., in the USA, the 50 state names), I don't
understand what speedup you hope to see.

--
Good luck

Jeff Boyce
Access MVP

"Alan fIsher" wrote in message
...
I am looking to import some lookup tables at startup to
speed up the database. I am using make table queries which
work fine except for one problem. The new tables are
created with the subdatasheet name set to auto which
really slows things down. Is there a way to go in and set
this value to none or is there a better way to accomplish
this task than to use make table queries? Thanks for any
help.