I never found this issue before... but since I start my developmennt yesterday in the office, I found this issue while I was trying to do so QA test on my project.
Here is the story :-
in VB, I open a recordset named "rs1" connected to the database for data view using rs1.MoveNext and rs1.MoveFirst. then I try to update one of the data using BeginTrans,Execute and CommitTrans.
At this point, the rs1 no longer work and I got an error message "Catastrophic failure". Why?
rs1.BOF and rs1.EOF both become "TRUE", how can it be happened?