Access 2003 Delete Queries

E

Ed

Is there a patch for Access 2003 concerning delete queries using two tables?
I have found that when running these queries I must add the language
"distinctrow" in sql view for the query to run.
 
A

Allen Browne

That doesn't need a patch, Ed.

You don't need DISTINCTROW if you are deleting from just one table.
With multiple table, it is important information for JET.

If you prefer, you can get JET to and the word by setting Unique Values to
yes in the Properties of the query.
 
Top