Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Deleting duplicates (97)

    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?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Deleting duplicates (97)

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

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Deleting duplicates (97)

    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)

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Deleting duplicates (97)

    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.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •