Importing lookiup tables at startup

  • Thread starter Thread starter Alan fIsher
  • Start date Start date
A

Alan fIsher

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