Access - Form with Tab control - multi tabs w/ multi sub froms on each - Cannot Open any more DBs
Posted on 2014-01-19
As some know I've been working on a db that I have split Frontend-Backend. My main input form has a tabcontrol. I have multiple tab pages and on each of those I have multiple subforms (some with their own subform).
I just went to one of the Page's subforms and clicked a combobox and get "Cannot open any more databases". ?????????? First time I've hit this.
Couple of questions.
Is there a way, while I have the main form open and am switching between pages to have a textbox populated on the main page to display how many dbs are open so I can tell how many are actually open?
Since a many of my forms use DAO.recordset is there a way in the VB project to scan all forms to open forms with dao.recordset so i can make sure I've SET all dao's to closed after their processing.
If I haven't executed a form with DAO.recordset would that even be part of the problem??
Basically looking for input on where to start looking.