Meaning of DISTINCTROW and ROW in a DELETE query

[BruceG]

Hello,
I have inhereted an 8-year-old Access database that I am currently "gutting" and in some of the DELETE queries I am seeing DELETE DISTINCTROW ... and DELETE ROW ... These are single-table DELETEs, so I am wondering if these keywords are unnecessary. I am used to coding DELETE statements as simply DELETE FROM tablename WHERE ... The question is can I safely remove these excess portions of the queries?

 

[hneal98]

check this out...

http://support.microsoft.com/?id=168438

Microsoft basically says that unless you have more than one table linked, the distinctrow has no affect.

 

[BruceG]

Thank you for taking the time to respond. I figured as much, but was looking for confirmation.