Deleting duplicates (97)

Topic

New Reply

I have a backup table and I want to add UPDATED records to it.. BUT delete the previous copies of those records from the backup table. I have a LastModified field which I can use to find the most recently modified record. Any idea how I might proceed?

Reply | Quote

Replies

Do you have a unique ID by which you can identify the records, or would you have to find matches another way?

Reply | Quote

Hi Andrew…

Any particular reason why you don’t just update the old records with the new information?… (rather than deleting them and adding new ones)

Reply | Quote

Is there a particular reason you want to delete the old copy of the record – I presume this is essentially an archive process. We typically leave the old records there for a period of several months or even years before we delete them so we have a history. Doing archiving in Access is fairly difficult because you need to deal with when a record gets saved, whether changes have actually been made and those sorts of things. SQL Server can do all this transparently by using triggers, but Access lacks that facility, so it must be done from forms – there is no way to add that functionallity to changes made at the table or query level.

Reply | Quote