MS Access Performance, How do I deal with #Errors, Out of Memory...

[Rashar S via AccessMonster.com]

Hi,

I have a very large complex application that I run, and what it basically
does, is grab data from the network, and dumps the data into an excel file.
It does this for multiple records, and after the 6th or 7th record at random,
you start to see #Error messages pop up, or out of Memory erros.

My system is xp 2 gig, 512 ram, with about 80% free HD space. I am using
Access 2003, Office XP SP1. If i update to Office XP SP2, would this
elimanate the errors, and memory issues that I am having?

Any other suggestions?

Thanks in advance,

Rashar