Cannot open any more databases

  • Thread starter Thread starter Trevor Bourne
  • Start date Start date
T

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.
 
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
 
Many thanks for your assistance.
The problem has gone away after following your advice.
 
Back
Top