Table merging via query?

[DennisJones]

I want to update the records in a local Access table every few days by downloading from an ODBC database server connection. How can I write a query which will allow me to "merge" the local and remote tables? (99% of the data is unchanged). I have tried an append query which sort of works but generates error messages in the process.

I can't use a "make table" query since any relationships would be destroyed in the process.

Any suggestions?

 

[ajetrumpet]

I think you are going to need an SQL PASS THROUGH query, however, I have no experience with this stuff. maybe someone else here who does have could help you more...