🚀 go-pugleaf

> However after processing in excess of 18,000 records (18408 to be exact,
> not counting 'child' records ) I get
> ______________________________________________________
> Access Violation at Address 4E5FA1F6 in module 'IDDAO32.DLL'.
> Write of Address 0000 0000 .
> ______________________________________________________
> 
> while running under NT4
> 
> or
> ______________________________________________________
> Access Violation at Address 4E5FA1F6 in module 'IDDAO32.DLL'.
> Read of Address FFFF FFFF .
> ______________________________________________________
> 
> under Windows 95 on the same record.

You probably have a memory leak.  If you watch under NT4 using the Task
Manager, you will see your memory usage slowly go up, until you run out
of money.  To avoid this you should do several things:

	1) Make sure you have the latest version of BDE (now at 5.0).

	2) the latest version of ODBC (I believe it is ODBC 3.5).

	3) Break your transactions up so that your program can run in parts,
eg. do 1000 records as part of one transaction and commit.  Then do
another 1000 records.  If it falls down, you can restart from a given
point, rather than at the beginning.

	4) Find the source of the memory leak (good luck).

Oliver