DELETE tblaccounting2.*
FROM tblaccounting2;
DELETE FROM tblaccounting2;
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.
That sounds as the table isn't linked properly.
Delete the linked table and recreate the link ensuring that a primary key is selected.
I don't know however, what was wrong with that table.
I hope it does not happen again.
This is the sql view of the query:
DELETE tblaccounting2.*
FROM tblaccounting2;