Hello, thanx for the info. I tried repairing the database thru the API as well the Tools->Database Utilities->Compact & Repair, neither is any good. Thanx for Tip 2, but that is good for checking AFTER the program, i need to make sure the data is not corrupted before this happens. This only happens when I close the application while it is listening to msgs over a TCP socket AND updating the database. If i close the sender first and close this receiver application everything is fine, otherwise, the table is empty. there was an exception in CDAOCore.cpp earlier at Line 39, but that was supposed to be a bug in MFC and I fixed it by compiling the code with MFC statically. i have been programming for a long time but this has really got me in a fix, i cannot see a pattern here at all. :confused:

fine, that's ok but before i close it with the cross on the console or thru ctrl-c i see CDaoRecordSet::GetRecordCount() returns 11, 12, 13. When i open the mdb file in access, the table shows zero records. i am not using daoworkspace, is that the problem?