I have a continuous form of records (about 4000) that get selected and gets
processed. Each record is processed with a call to a local Private Function
in the same form, and that function calles a public function in a code
module. After about 2000 records, the routine stops with a 3035-System
Resource Exceeded. From a coding standpoint, I have closed all of my open
tables at the end of using them, only passed the fields that I need whenever
I open a table, Set my database variable to Nothing after using it. Nothing
seems to help.

I have watched the Windows Task Manager Performance monitor which shows I
have plenty of memory left, although the Handles counter advances at a very
rapid rate. It goes from about 7000 when I start to about 80,000 or 90,000
when it stops.

I am using Access 2003 program database with SQL Server 2000 tables linked
via ODBC.

Any ideas on how to troubleshoot this would be appreciated.
Paul