Troubleshooting Action Queries
Access analyzes your action query request and the data 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 that 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 and ContactDateTime, ...
Get Microsoft® Office Access 2003 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.
