Systmatic Update of Reference tables

[bassman71]

Hello,
Just wondering: is there a utility in Access that updates records on reference tables automatically? Right now I use make table queries based on a master table that over-write existing ref tables. Is this the only way to do it?

THanks............Rick

:dunno

[XLGibbs]

You can tie your make table queries into the Macro designer, turning the warnings off and executing them in sequence to make it simpler.

The other alternative would be Update queries or Append queries to add new data.

It would help if you were a little more specific...you say Update Records on reference table...

where does the new data come from? If there are userforms or other tasks that are involved, there may be a lot more options.