Update Qrery

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

At this time, I have a database that is resident on each computer. I link
the tables to that database across a statewide network and have the master
data file on a server. The lag time is very slow and I need to do something
to speed it up. I understand how to do an append query but this only adds
new records to it. I need to be able to update a table with any record that
has been changed in any way. In other words I need to create a query that
will completely change the record weather it a new or existing record.
Thanks for the help
 
Does the resident database on each computer contain only UI objects? Is the
"Master Data File" contain only tables?
What is causing the lag?
Are the forms that you are using bound to the MDF tables?
 
Back
Top