No more databases can be opened

  • Thread starter Thread starter Eli Cohen
  • Start date Start date
E

Eli Cohen

I recently developed a form that is used as a calendar.
Basically it's programmed to automatically fill in all the
appropriate dates for a 25 block form that represents a
selected month and year. I am using this form as a
scheduler. Each block has 30 comboboxes. I could not
insert that many comboxes on one form, so I created a
subform and inserted it 25 times. Everything looks great
and functional from the first look. When I started
entering data in each block, actual scheduling, and got to
the third week or so, I got an error message stating " no
more databases can be opened" and the comboboxes stop
functioning, only showing a blank field when drop downed.
I really got frustrated and am not able to go around
this. Are there any suggestions?

Thanks,
Eli
 
I can only comment generally.

The error message stating " no more databases can be opened" is not what it
seems; it does not literally mean databases! This error message arises when
Access stops processing due to complexity issues in the design of your database.
The issues are:
1. too many calls for data from the same data source (usually tables)
2. too many calls for data in all open objects such as queries, SQL, domain
aggregate functions, etc.

My bet is that you have exceeded issue 2.
 
My comboboxes are looking for data in a couple of tables,
if I remove the DlookUp and just insert list of items will
it help? Is there a way to alleviate/change the maximum
amount of calls?

Thanks,
 
<< if I remove the DlookUp and just insert list of items will it help? >>
Domain Aggrgate Functions count significantly against complexity. Removing a
DLookup will greatly help but may not on its own be enough. The decision to
remove it for a list of items weighs on flexibility; you now have the
flexibility to add items to the table the DLookup refers to. With a static list
you lose that flexibility.

<<Is there a way to alleviate/change the maximum amount of calls? >>
Consolidate queries where you can and reuse queries where you can.

Steve
PC Datasheet
 
Back
Top