I have programmed an application which uses MsJET 2.0 engine in order to fill a log in mdb format, so since it is a log the database receives a lot of datas a day (near 700 recorsets a day). The problem is that I've noticed that sometimes my database suddenly get blocked: instead of adding and editing a new recordset, the new datas replaces the old ones that is to say that the datas are updated, but not added at the following of the file. A symptom of this odd behavior of my DB consist of some blank recordsets added from time to time between the "good" recordsets before the DB get blocked.
Please, if you have the slightest idea of what happen, I would be thanksful that you reply me, the release date is near and I still don't know where does the problem come from. :-)