Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Connecticut USA

    Which duplicate?

    I want to load 3,00 more records into my database. I know I will be loading some records which already exist in the db.
    I usually use an append querry, and set the primary key to to the field that will strip the duplicates.
    However my concern is that many of my exisitng records have many notes. When I do an append query, how do I know which dups will be deleted, obviously I dont want to delete the existing records, that contain notes

    Thank you for reading this


  2. #2
    Join Date
    Dec 2005
    Wilmington, DE - USA

    When you run your append query, if there is a primary key conflict, then the record you are attempting to append does not get appended, leaving the original record intact.


Please reply to this thread with any new information or opinions.

Similar Threads

  1. duplicate autonumber
    By rayc in forum Access
    Replies: 5
    Last Post: 06-19-2013, 07:50 AM
  2. Duplicate command button
    By brettg in forum Database Design
    Replies: 1
    Last Post: 08-04-2008, 04:16 AM
  3. Duplicate add to new table
    By horseyshoe in forum Access
    Replies: 3
    Last Post: 09-01-2006, 07:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums