98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Update query to Update modified records only | Access forum
Update query to Update modified records only | Access forum
Resolved · Urgent Priority · Version 2013
Thu 28 Jan 2016, 10:51Delegate Marco said...
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
Thu 28 Jan 2016, 14:13Trainer Doug said...
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
Thu 28 Jan 2016, 16:57Delegate Marco said...
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
Fri 29 Jan 2016, 17:15Trainer Doug said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Copy a Previous Record's Values to a New RecordIf you often enter the same value in one field of a table, there are two methods to save re-typing the data. |
