🚀 go-pugleaf

Well, I don't know what the problem was, but a reboot solved it!


> 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
>
>