Cannot open any more databases

[Trevor Bourne]

I am getting runtime error 3048 Cannot open any more
databases. I believe this is occuring while the code in a
module is running which includes dim db as database - set
db = Currentdb etc. Can anyone please suggest why this
might be happening. Your response will be much
appreciated as I have spent hours trying to trouble-shoot
this with no success.

 

[Roger Carlson]

In each subroutine where you define a database variable, do you also close
it and set it to nothing? Like this:

db.close
set db=Nothing

 

[Trevor Bourne]

Many thanks for your assistance.
The problem has gone away after following your advice.