Access2003 SP1

[hog]

I have spent 3 days working thru another programmers application which is hanging on the outputto method when outputting to rtf format.

 

I won't bore you with all the nitty ****ty detail of this app apart from that it cycles thru many records and gets so far and just hangs. I then remove a number of records and the app works perfect as before.

 

From my investigation all I can presume is that buried somewhere in the app some resource is being consumed and when it reaches it's limit it hangs?

 

I have looked to check that there are the required .close and set to nothing of recordsets etc and all appear to be there.

 

Is there a method/function which can be called to force Access to clear up similar to the garbage collection in .NET.

 

Thnx

[IxiRancid]

I don't understand actualy are yuo inserting into Access or just browsing thru Access records?

If you insert: how many records are there? Both Excel and Access have it's limits. I noticed some kind of a solution in Excel, where new Sheets are created, when there is excess of records. But I don't know how Access acts.

 

If you suspect resources, then you should post some of the "risky" part of your code.