Delete Query Error

Vesuvius

New Member
Joined
Jan 11, 2011
Messages
44
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.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

james_lankford

Well-known Member
Joined
Jan 11, 2009
Messages
1,172
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

New Member
Joined
Jan 11, 2011
Messages
44
Excellent!

That resolved the issue.

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

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,468
Members
409,883
Latest member
asharris90
Top