Cannot open any more databases. (Error 3048)

R

Risky

I'm getting the error "Cannot open any more databases.
(Error 3048)" fairly randomly when I run queries. The
database is in Access 2000, using DAO/JET with only one
user and about three linked data databases.

Any assistance whould be greatly appreciated.
 
R

Risky

Oh and there are no remote databases opened in code. All
connections are effected by linked tables. I have found
suggestions that I insert a lot of Set rstX=nothing / Set
dbsX = nothing and will try this but I getting the problem
when only viewing queries from the db window
 
Top