Deleting dupicate records

[Guest]

I have Access 2000 - there was a time that I could run a duplicate query on a single table and the query would allow me to delete the duplicates. It is now telling me that it is read-only and will not allow me to delete. Is there an option somewhere that I need to select or deselect. I have checked permissions and I have full admin rights.

Thanks!
V

 

[[MVP] S. Clark]

What changed in the application since the time you could, until the time you
couldn't?

Also, read the help file about the rules of updating the underlying tables
of queries.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

I have Access 2000 - there was a time that I could run a duplicate query

on a single table and the query would allow me to delete the duplicates. It
is now telling me that it is read-only and will not allow me to delete. Is
there an option somewhere that I need to select or deselect. I have checked
permissions and I have full admin rights.