"Cannot open anymore databases"

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

I can't get rid of this error. It's true that this statement is executed
many times:
Set rstClassDetail = CurrentDb.OpenRecordset(ls_temp),

and there are similar RecordSet.Opens elsewhere, but I've looked and looked
and can't find anyway that an Open happens without a corresponding

rstClassDetail.Close
Set rstClassDetail = Nothing

I don't assign the database to a variable anywhere. Instead I use
"Currentdb.Execute"..... Etc.

What else might I look for to try to get rid of this error?
 
Go to the newsgroup comp.databases.ms-access and look at the thread on 8/13 at
8:14AM.
 
Thanks.... not surprisingly, this leads me into research on Outlook Express.
I can't remember/figure out how to add a new newsgroup account, and one of
my 3 (forums.sybase.com) no longer works.....

However - I did stumble on the problem. I had created a recursive
situation. A call to the top level calling routine was buried in the depths
of the logic. I think all of my .close and =nothing code was probably
executing, and it must have been the recursion itself that caused the
overflow.
 
Back
Top