Unable to delete record in datasheet view

[thatlem]

I have a query which runs off one table. No calculations, no code, etc. just pulling fields down from the table. End user entered a duplicate record and is unable to delete. Have verified all delete functions are greyed out, and unable to delete record. I would think a simple on/off switch, but I can't seem to locate one. Any suggestions???

 

[DCrake]

You should not be deleting records in datasheet view for a start.

also are your tables linked? If so, where are they sourced from? what type of table are they? Do you have the rights to delete? More info needed.

David

 

[thatlem]

Deleting records from a query is not a problem. I define databases for users to do that all the time. You certainly don't want users deleting directly from the tables. Access uses queries to update tables all the time - hense append queries, update queries, etc.

This is an especially easy situation as it simply is all the fields from a single table. There is no code, no calculations, nothing that could "in theory" go wrong.

I have seen some indications of bugs relative to this sort of issue, but they seem to be related to subforms or multiple tables linked together - which does not apply in this situation....

Again, any suggestions would help.

 

[thatlem]

Ever have a "duh" moment. I just rebuilt the query and it works fine.