Hi,

On a current project, records are "supposedly" inserted into a database. VB5 Interface, Access database. The problem is that sometimes, there are records which do not "make it" into the database. Meaning the user inputs the data, clicks the button to insert it into the database, all checks are done, no messages appear and all goes as it's supposed to, that is until records are noticed to be missing.

The funny thing is that it can happen for one record, then not for 5,10 or even 25 next ones, or it can happen for 30 in a row, then go on a long stretch where everything's ok. Anyone have any idea what could be causing the problem? The thing is that I cannot get the problem to reproduce on my station (the development computer) no matter how much I try.

Any idea/suggestion would be very much apreciated,

TIA,

Hugo Dahl