I am using MS-ACCESS as a front end. MySql as Back end.
I have a DELETE query, to delete the content of a Table (No conditionals on the query at all, so delete all the records in the table).
But for some reason, the query is deleting all the records, except one record. I executed the DEL query again an still not able to delete that specific row or record.
Also, the table shows #delete# in all the fields if I open the table, but if I refresh the table, the same record appears again.