No more databases (1 Viewer)

[evanscamman]

I'm getting the 'can not open any more databases' error with Access 2010.
This happens whenever I have about 6 forms open. I know some of my forms are pretty big, so I'd like to find some way of measuring how much each form eats up. Then perhaps, I can rework a single problem form.

Is there a command or tool that will report the # of database connections currently open?

Thank you,
Evan

 

[Pat Hartman]

I've never run into this. Under production conditions, my apps would never have this many forms open but when I'm testing, I frequently have this many or more objects open. Have you compacted the database recently? Try creating a new empty db and importing all the objects. One thing you should look for though is DAO/ADO recordsets that you open in VBA should be closed when you're done.