Error 3128 when trying to delete records

Question

I am attempting to debug an application done with MS Access 2010.  There is a failure with error 3128 - specify the table containing the records you want to delete.  This happens on the first step of a macro that opens a query with the following statement:

DELETE [Receivelog Details].*, Receivelog.[ROR No]
FROM Receivelog INNER JOIN [Receivelog Details] ON Receivelog.[ROR No] = [Receivelog Details].[ROR No]
WHERE (((Receivelog.[ROR No])=[forms]![Do Manifests].[selectROR]));

I am able to execute a datasheet view with query and get the correct results, so I don't think there is a problem with the WHERE section.  I am confused as to why it feels I have not specified the table.

Any assistance would be greatly appreciated!!

W. Brown

[e-mail]

Answer 1

>>>There is a failure with error 3128 - specify the table containing the records you want to delete.  This happens on the first step of a macro that opens a query with the following statement:

According to your description, if using an inner join in conjunction with a delete query (which can sometimes be a problem), so I suggest  you could try this instead:

DELETE [Receivelog Details].*
FROM [Receivelog Details]
WHERE ((([Receivelog Details].[ROR No]) In 
(SELECT Receivelog.[ROR No]
 FROM Receivelog INNER JOIN [Receivelog Details] ON Receivelog.[ROR No] = [Receivelog Details].[ROR No]
 WHERE (((Receivelog.[ROR No])=[forms]![Do Manifests].[selectROR])));

In addition could you provide more information about your issue, for example macro code, screenshot etc., that will help us reproduce and resolve it.
Thanks for understanding.

Answer 2

As you are restricting the query by a parameter on the key, why do you need to reference the ReceiveLog table at all?

DELETE *
FROM [Receivelog Details]
WHERE [ROR No] = [Forms]![Do Manifests].[selectROR];

The only reason I can think of is that there are rows in Receivelog Details without a match in Receivelog, which you want to retain.  This would be unusual as it is normally the case that it is rows without a match which are to be deleted, not the reverse.

BTW I'd strongly advise against including your email address in a post to a public forum like this; it's an open invitation to spammers to harvest it.  If you do need to cite the address then mung it, e.g. wallybrown61<at>Hotmail<dot>com

---

Ken Sheridan, Stafford, England