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 wont 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 its 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 dont 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 its limits. I noticed some kind of a solution in Excel, where new Sheets are created, when there is excess of records. But I dont know how Access acts.

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