Cannot open any more databases. (Error 3048)

[chonming]

I received the following message when I tried to open one of my report second
time.

"Cannot open any more databases. (Error 3048)".

I had to restart my microsoft access in order to view that report and other
objects in that database. The 'Microsoft Office Access Help' informed my that
I had reached the limit on the number of databases that can be opened at one
time. I had to close one or more databases and try the operation again. As
the query that I used to generate the report opened too many tables and
queries, I had no idea how to close it after I used it. I would like to know
the solution to avoid this error message so that my database can run smoothly
everytime.

Anyone who know the method to solve this problem, please kindly reply this
post. It's urgent. Thank you.

Regards,
chonming

 

[Van T. Dinh]

Not 100% sure but do you have code something like:

Set db = CurrentDb()

or

Set db = WS.OpenDatabase ...

or similar in a loop?

The reason is that the WorkSpace can only have 256 Database objects (Access
uses 3-4 intances internally) and you can hit the limit fairly quickly.