Hard limit on INSERTs

J

Joel Whitehouse

Hello All,

I am converting a VB6 database front end to a VB.NET interop ADO
database front end over MS Access 2003 (I know, I know, Interop is a
terrible waste of resources... I'll upgrade to ADO.NET later.)

Anyway, when I run my program, I try to INSERT INTO a table from a for
loop that runs 128 for 128 iterations. I have stepped through this loop
to verify that it iterates 128 times, but when I open the .mdb file in
access, only 84 dataponts have been added. If I run my program again, I
can add more datapoints to this table... but no more than 84 of them.

Any ideas on what is causing this limit?

Thanks!

-Joel
 
Top