Delete Query Error

[Vesuvius]

I get this error when executing a simple Delete Query.

"Could not delete from specified table."

First off the database is local to my machine and I just created it yesterday so it is not read only or is it a permission issue.
The query works fine as a select query or when I view the results but when executing I get the error message. Here is the SQL code that was generated when I setup the query using the two tables.

DELETE ZPPMRPHistory.*
FROM OmitItems INNER JOIN ZPPMRPHistory ON OmitItems.SAP = ZPPMRPHistory.SAP;

The first time I have had any issues with such a simple Delete query.

Any assistance is appreciated.

 

[james_lankford]

try this

close access
COPY the database and make a BACKUP

now open the original database
open your query in design mode
then from the menu, choose View and then Properties

set Unique Records to true
run the query

that may work

I had a similar problem a few months ago and I think that was the solution, but I'm not positive

 

[Vesuvius]

Excellent!

That resolved the issue.

Thanks so much. I have never seen that happen before.