Question SQL Delete Problem

[Galaxiom]

Queries in code can be constructed dynamically allowing for possiblities not supported in a stored query.

It should be obvious that I was talking about static queries which are far and away the bulk of the queries in any application..

That depends on the style of the developer. I work with databases where a subform recordset would start with half a million records if I used the usual LinkFields construction. I get orders of magnitude better performance with dynamic RecordSource queries, though I have now moved on to recordsets based on Server Stored Procedures because they respond instantly

Sorry that my question has produced such dissent amongst such a high powered peer group

The lively discussion is often where the most interesting stuff comes out. Don't mistake it for any kind of animosity.