Deleted records in query don't delete from table

[topher23]

I have a query that isn't working as expected.

The query links to one table used for data entry and has outer joins on two tables used to display information based on choices entered.

I can enter all the data I want and it works fine, and if I delete a record in the query, it disappears from the datasheet. However, if I close the query and reopen it, the deleted data is back - it didn't delete from the table. What's going on?

I'm using MS Access 2003 with the post-SP3 hotfix.

Just for clarification - I normally don't use this query as a datasheet, but as the recordsource for a form. I noticed first that my "Delete" button wasn't working properly, then backtracked to the query and realized that the problem must be structural rather than code-related. I still want to know what the deal is, but I suppose I could just write a delete query for the specific record from the table as a workaround rather than using acCmdDeleteRecord.

[emsik1001]

Hmm interesting

I haven't come across this before and I would think that if youry query is not somehow set up as read only then you should be able to do that.

I don't have a solution for that so I hope other members will be able to help more then I.

Regards
Emil

[topher23]

Just to put some closure on this - I gave up on acCmdDeleteRecord in this case and used an SQL Query to delete the record, as I was musing about in the original post. Thanks Emil.

[NeoPa]

I wouldn't expect a query with outer joins to be updatable anyway. That doesn't really explain it though, as I would expect it to report this as a problem if you tried to do a deletion, rather than look like it had worked, only for the changes not to be reflected in the underlying table.