Error in table name or view name in DELETE clause: <Stringname> not recognized.
There is an error in the syntax of your query. The Query Designer has attempted to locate the source of the error. Review your query syntax and correct the error before running your query. Be sure to use Quoted Identifiers as needed.
For more information, see Specifying Search Criteria (Visual Database Tools) and How to: Create Queries (Visual Database Tools).