Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Question Unanswered: Question about append queries

    Hi everyone,
    I have a question about append queries:
    When I run an append query somtimes I get message that some records couse key violation or not meet the validation rules but I can't find which records!
    When I copy data to a table, if there is a problem with keys or validation rules Access generates Paste Errors table which shows the records that cause the problem.
    Can I get something similar with append queries so that I can find those "problem" records!
    Thak you in advance!

  2. #2
    Join Date
    May 2004

    Trap Error

    Perhaps you could try trapping the error when it occurs and write the current record to another table.

Posting Permissions

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