Deleting dupicate records

  • Thread starter It shouldn't be this hard
  • Start date
I

It shouldn't be this hard

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
 
M

[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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

It shouldn't be this hard said:
I have Access 2000 - there was a time that I could run a duplicate query
Click to expand...
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.
 
Top