Append new and changed records

[Apprentice]

I have an Access database that I use as an analysis tool. I import several
tables form a larger database. The Records I import may or may not have been
edited in the main database. I can easily append new records from the
database, but I also want Access to recognize records that have been changed
since the last import and overwright those records.

Any thoughts.

 

[Douglas J. Steele]

Check my November, 2003 "Access Answers" column in Pinnacle Publication's
"Smart Access".

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Dorian]

You need a 'lastupdated' column in each table. This column must be updated
each time a row is changed.
You will compare on this row when you do the import and replace all records
where the lastupdated column is greater that the date you last imported.
You could also just simply replace every existing record which would do the
job with some extra work.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".