Not Allowed To Run Delete Query

[batowl]

I am trying to run a delete query, but I keep getting the error message: "Could not delete from specified tables". The database is not read-only and I have permissions to make plenty of other changes to the table I am trying to delete records from.



I set the query up exactly how Office Online describes it should be done. Sure enough, when I switch out of design view and into database view, I see the appropriate records that should be deleted, but when I try to actually run this query, I cannot. Any suggestions?

[RuralGuy]

This link may be useful: http://allenbrowne.com/ser-61.html

[batowl]

Hi - thanks for the clarification. According to that website, it would seem that my problem lies in the fact that I have a grouping clause and according to the site, if the query "has a GROUP BY clause. A Totals query is always read-only."

I would normally drop it there, but that does not explain why Microsoft's own instructions indicate that this is the proper way to go about building and running this query:
http://office.microsoft.com/en-us/ac...in=EC001022370
Under the section on
I want to delete records that are duplicates of others.

they have a portion of the query that includes <> [Distinct].[MinOfHireDate]
in the Criteria field of the query.

Basically, I just have a table with multiple entries for a single individual. All I want to do is eliminate the duplicates (and sometimes triplicates) within this one table and be left with one record for each person. If there is an easier solution to this problem, I would love to know! Thanks!!

[RuralGuy]

I'm afraid I cannot explain how you are interpreting the Microsoft site as my internet connection is acting up. I suspected you had a read only Recordset from your original description which is why I provided the link I did.

[batowl]

That's ok. I am going to read up on all this a bit more tonight and have at it with a fresh mind in the morning. Thanks for the link, did not know about the read-only status of queries with grouping before!

[RuralGuy]

Good! Are you ready to use the Thread Tools to mark this thread as Solved?