Delete Query Error

[Guest]

HELP! I am getting a "Could not delete from specified tables. (Error 3086)"
error when trying to run a Delete query. The delete query joins a table with
a select query - one of the joined fields from the query is a calculated
field. The Delete query is trying to delete from the table, not the query.
Any ideas what is causing the error?

 

[JohnFol]

Have a quick read of
http://support.microsoft.com/kb/240098/EN-US/

 

[Guest]

Thanks for the response - I have changed the UniqueRecords Property of the
query to YES and I am still getting the same error. The SQL of the query is

DELETE DISTINCTROW [Tbl WS].*, [qry WS OS].[Full VIN], [qry WS OS].Primary
FROM [Tbl WS] LEFT JOIN [qry WS OS] ON ([Tbl WS].Dealer = [qry WS
OS].Primary) AND ([Tbl WS].VIN = [qry WS OS].[Full VIN])
WHERE ((([qry WS OS].[Full VIN]) Is Null) AND (([qry WS OS].Primary) Is
Null));

[qry WS OS].[Full VIN] is a calculated field combining two text fields.

If anyone has any thoughts, I would appreciate it!