O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required