Delete Query

I'm uploading data from a table that I need to refresh from time to time. I need to basically delete all of the data & then I repopulate again with fresh data.

I can't seem to get the query to work using either of these query options:

The error message I receive is Single-row update/delete affected more than one row of a linked table. Unique index contains duplicate values.
The table itself resides on another machine cennected via OBDC. I can update with ease, just can't seem to delete???

re: Delete Query

**BUMP*** anyone have any ideas what the error message above means??

Cheers, Stevo

re: Delete Query

Two things to try:

Have a look-see on how you're linking to the fields in the backend. For instance if you are opening the table through the .OpenRecordSet method there is a setting called dpAppendOnly that will allow additions, but no deletions. If you have all permissions, try changing the syntax of your delete query:
Regards,
Scott

re: Delete Query

When I hit this error message the problem turned out to be exactly as described in the error message: Single-row update/delete affected more than one row of a linked table. Unique index contains duplicate values.

This was because of a mismatch between the underlying definition of the table in MySQL and the (out of date) definition in MS Access. What Access thought was the 'unique index' was not, in fact.

The solution was to relink the table in Access using the Linked Table Manager.

Hope this helps someone!