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
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.
