Troubleshooting Action Queries

Access 2010 analyzes your action query request and the data that you are about to change before it commits changes to your database. When it identifies errors, Access always gives you an opportunity to cancel the operation.

Solving Common Action Query Errors and Problems

Access identifies (traps) four types of errors during the execution of an action query.

  • Duplicate primary keys. This type of error occurs if you attempt to append a record to a table or update a record in a table, which would result in a duplicate primary key or a duplicate of a unique index key value. Access will not update or append any rows that would create duplicates. For example, if the primary key of a contact event archive table is ContactID ...

Get Microsoft® Access® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.