Marco has attended:
Access Introduction course
Access Intermediate course
Update query to Update modified records only
I have a table (which is a live link to a website), every night I want to run a update query to update my local table with any updates made on the web table. There are 55,000 records in both tables with about 25 columns. The update query is taking extremely long to update due to size of data. Is there a way for the update query to look at the differences in data first and only update fields that are not the same?
Thanks for your help.
Marco
RE: Update query to Update modified records only
Hi Marco
I'm not able to help at this stage with links to your website database. However if there is a field in the table containing the date of update then a criteria can be included in the Update query.
There is also a Find Unmatched query wizard in Access that shows the differences between tables. (Create, Query Wizard).
Please let me know if you want help with this or adding criteria to an Update query.
Regards
Doug
Best STL
RE: Update query to Update modified records only
it's not the link to the web site that is creating the issue. How do I attach a file on here? I can send you the update query I have created already. However, this query runs and updates all records regardless if the information is the same or not. I want to get to the point where it only updates the fields if they are not identical.
Marco
RE: Update query to Update modified records only
Hi Marco
You can send as a zip file to info@stl-training.co.uk
and ask to be forwarded to Doug Dunn.
I can look at it early next week. Cheers for now.
Regards
Doug Dunn
Best STL
