[AccessD] Runtime error 3048 -- Cannot open anymore databases

Howdy. First-time on AccessD.

I've tried all the other forums and can't get an answer to this one.

I have a FE A2007 app linked to a BE A2007 database. There's a master form
with 6 tabs. Each tab contains a subform that's bound to a query. Plus I
open recordsets on the the BE tables to fetch stuff for the form. You can
drill down from any subform to a detailed form by double-clicking a data
field. I started getting the above error message after opening 2 or 3 of
these forms, so I created a form handler method that shuts down the calling
form and closes all the DB connections before opening the target form. I'm
still getting that error. I've gone thru my code and diligently set all DBs
to nothing at the end of each sub, but I can't seem to lick the problem. 

 

Suggestions from other forums have been to unbind the tables from the
subforms. I buy that, but the question I can't get an answer to is how can I
monitor how many connections I have open at one time so I can diagnose the
problem? I feel like I'm debugging in the dark.

 

Please turn on the light for me.

 

Thanx,

Darrell