Ive made improvement now, thanks for your reply.



"Dave Patrick" wrote in message
...
Still doesn't help. Can you post the code?

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Goofy" wrote:
| OK, well to put this in context, I am generating about 7,000 records in
one
| hit. This takes approximately 90 seconds.