[AccessD] Access dies when writing large number of records

Gustav Brock gustav at cactus.dk
Fri Mar 14 09:35:00 CST 2003


Hi Neal

What happens if you write those validated records to a temp table,
then appending the temp table to the final table?

/gustav

>> Using Access2K on Win2K I'm importing about 30K records from a text
>> file.  The file is read line by line, parsed, and records created or
>> updated in the database as needed via VBA/DAO code.  The whole thing is
>> wrapped in a transaction.
>> 
>> When the transaction is enabled Access dies at about 2500 records with a
>> Windows generated message saying "MSAccess.exe has generated an
>> error..."  My error handler never gets invoked.  If I comment out the
>> transaction it runs fine.  I'm confident that the code is OK.




More information about the AccessD mailing list