Re: No more databases can be opened

From: PC Data*** (nospam_at_nospam.spam)
Date: 06/02/04 

Date: Wed, 02 Jun 2004 15:26:53 GMT

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. 

--
                                         PC Data***
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdata***.com
                                 www.pcdata***.com
"Eli Cohen" <anonymous@discussions.microsoft.com> wrote in message
news:171eb01c448a2$e29628d0$a501280a@phx.gbl...
> 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