Hi Missy,
Craig Berntson has a white paper on his website that talks about ICEs.
www.craigberntson.com. If you have not seen this, perhaps it will help.
I had a particularly difficult ICE one time that dealt with a SQL statement. On some computers, no problem, on other computers, it blew up. The only solution that worked to fix the problem on all computers was to break the SQL down into smaller parts. Perhaps you can try breaking your statements down into smaller parts.
HTH,
TFISHER
>Hi Peter,
>
>
> Thanks for your suggestions. The message in the Help wasn't very descriptive. Yes, I delete all my indexes and rebuild them from scratch before testing what I'm trying to run. As far as the memory goes, I had the Task Manager open the entire time the program was running. Although I did notice it spike up to 100%, this occurred much earlier in the program. The routine where it bombs out it was reading only 1% memory usage. If you happen to have any additional ideas, please pass along. Thanks much!!!
>
>-Missy
Thanks,
TFISHER