DELETE records are not deleted

[victorqedu]

I have a simple problem:
I use java to delete records in a .mdb file database.
When I delete something the access log says success but the records don't disappear from the table.
This is the log:



classes" StartC 1454-1afc ENTER SQLExecDirect
HSTMT 0x4B698A18
UCHAR * 0x4B0B2818 [ -3] "DELETE FROM Pacient_Fisa___SZ;\ 0"
SDWORD -3


classes" StartC 1454-1afc EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
HSTMT 0x4B698A18
UCHAR * 0x4B0B2818 [ -3] "DELETE FROM Pacient_Fisa___SZ;\ 0"
SDWORD -3


classes" StartC 1454-1afc ENTER SQLNumResultCols
HSTMT 0x4B698A18
SWORD * 0x4B66E9F0


classes" StartC 1454-1afc EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)
HSTMT 0x4B698A18
SWORD * 0x4B66E9F0 (0)

If I run the exact same command from microsoft access interface the DELETE works fine.
Thank you.

[June7]

So this is a Java, not Access, issue?

What is an Access log? Where does this info come from? Never seen this before.

[victorqedu]

In Control panel/administrative tools/data sources, tracing tab you can set a log and you can see every query running on the selected database.

I made it, the records are deleted now but is not clear why.
Solution was to close the database connection from java.
But other .mdb databases don't have this problem. On other databases I can INSERT and DELETE without closing the connection.
I also tried to commit before closing but commit has no effect.