🚀 go-pugleaf

I am trying to work with an Access 2000 database using BCB5 and ADO (with
all patches applied).  I have Paradox tables that are duplicates of the
Access tables that I have linked into the same Access database for test
purposes.  I am appending about 4,000 records into a master table and 32,000
records into a detail table in one operation.  I'm using the Jet 4.0 OLE DB
driver and TADOTables.

Although slow, the operation works as it should with the linked Paradox
tables.  However, Access is acting strangely.  While the appending is going
on, the detail records are showing up (viewed from Access).  However, about
2/3 of the way through the operation, there is about a 5 minute pause, and
the prior detail records appear to be lost.  When the operation is committed
and completed, the records imported thereafter are retained, but none of the
prior ones show up.

Is there a cache problem, or something like that going on here?  Any ideas?

Mike Lewis