Update query to Update modified records only | Access forum

Resolved · Urgent Priority · Version 2013

Thu 28 Jan 2016, 10:51 Delegate 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:13 Trainer 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:57 Delegate 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:15 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips