Command Other than Append

[drunkenneo]

We know when executing append query in a table if the query executed twice, then duplicate data get inserted,



Is there any other best solution to avoid such cases?

[June7]

Options:

1. avoid the situation - why are you using append query?

3. have code check if data already in table and don't run query if already in table

However, if users have access to objects in the navigation pane, and the append is a query object as opposed to a VBA executed SQL action, nothing will prevent them running the query object.

[JoeM]

Also, if you have some unique primary key identifiers built-in (that aren't autonumbers), this will also prevent the duplication of records (as it would be a key field violation to try to add the same value twice for a field required to be unique).