Cannot open any more databases

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.
 
R

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
 
T

Trevor Bourne

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot open any more databases (3048) 4
Error - Cannot open any more databases... 6
Cannot open any more databases and splitting databases 3
Error 3048: Too many databases open 4
Splitting up dbs eats ressources 4
Access Run Time version crashes on Macro errors etc. 2
Error 3048 4
Can not open any more databases 1

Top