Deleting records via ESS not working

[Reed]

I've set up ESS with a SQL server 2008 database, and viewing/editing records seems to be working fine. The problem I've encountered is that when I try to delete a record via ESS, it appears to delete, but when I search for the record again it is still there (and it's there if I look for it in SQL server management studio) I get no error messages when deleting, and if I run a delete query in the SQL server management studio, the record really does delete in that case.

Has anyone encountered an issue like this where ESS does not allow deletion?

[Reed]

So a partial answer to my own question is that the data which I couldn't delete is being audited in SQL server. There are other tables which are not audited in which I'm able to delete records just fine. I just can't delete records in audited tables via ODBC or ESS. Still not sure why that is though.