[AccessD] Access dies when writing large number of records

Hi Neal,

Not knowing what your text file looks like,
I'm still going to recommend this:

How to Programmatically Create a Schema.ini File
http://support.microsoft.com/?kbid=210001

Mike Mattys
www.mattysconsulting.com

----- Original Message ----- 
From: "Neal Kling" <nkling at co.montgomery.ny.us>
To: <accessd at databaseadvisors.com>
Sent: Friday, March 14, 2003 9:30 AM
Subject: [AccessD] Access dies when writing large number of records


> 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.
> 
> This has worked fine for more than a year.  I recently updated to O2K
> SP3.  I found a KB article that addresses a similar problem that
> suggests one should update Jet to 4.0 SP6 which I have done with no
> effect.  O2K SP3 cannot be uninstalled.
> 
> Running this without the transaction is do-able, but not desirable.
> Does anyone have any ideas or suggestions on this?
> 
> Neal Kling 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com