In an Append query, what happens to any records that violate the Primary key (or any other) rule? Select one: A. The query pauses at each violating record and allows you to fix the error(s). B. A message box appears telling you that you must fix the problematic records before the query can be run. C. New Primary key values are added to the records D. The records are rejected.