Access 2003 Delete Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete query 2
Update a table from a query 7
Run 2nd query using results from 1st query 0
Access #Error & Excel Pivot 0
Parameter Value error in a Subform 0
Could not delete from specified tables 3
Linked SQL Tables don't report Cascading Updates and Deletes 2
Access freezes or hangs attempting to open linked ODBC tables 1

Back
Top