Update Table (1 Viewer)

[mark curtis]

I have a linked table that holds Change Controls call tblCC.

What I want to do is refresh the linked table and then copy all the data in tblCC into tblServices and overwrite any duplicate records thus only adding new ones.

My thoughts were to run a delete query to remove all the Change Controls from tblServices as I have a unique field to use as criteria but when I use an append query after that I get key violation problems.

What I would like is advice on which method is best or the SQL code that will add the records from tblCC to tblServices.

Thanks
Mark

 

[Pat Hartman]

Use the update query pointed to by this link. It will update existing rows and append new rows.

http://www.access-programmers.co.uk...d=49061&highlight=append+AND+update+AND+query

 

[mark curtis]

Thanks as usual Pat.