[AccessD] Cannot Open Anymore Databases

With reports, it's even worse, because a report when you open it creates
"shadow" queries so you are effectively doubling the connections you
designed into it.

Charlotte Foust

On Mon, Jul 11, 2011 at 11:20 AM, Darrell Burns <dhb at flsi.com> wrote:

> I had the same problem with a form that had 5 subforms, each with multiple
> queries. I submitted the question to every forum and discovered that
> there's
> no easy cure. The connections limit is 256 but there's no function to tell
> you how many you've used up. Connections to a back-end database count
> double. After spending lots of time re-engineering my recordset actions and
> being very meticulous about closing connections, the final solution was to
> bind the subforms to temp tables and fill the tables as each tab is
> clicked.
> So, your solution is the correct one.
> - Darrell
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
> Sent: Thursday, July 07, 2011 6:00 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Cannot Open Anymore Databases
>
> Hey All
> Just curious. I was working on a report, I would view it and when I
> returned
> to the design mode I would get the error message "Cannot open anymore
> databases". The report is based on a union query, which is made up of 6
> subqueries. each of these subqueries is based on the results from about 3
> or
> 4 other querys. If I manually run the union query I don't get any error
> messages, as I mentioned I only get the error message when working with the
> report. Am I correct in assuming that the results of each of these queries
> results in 1 instant of the database being opened and I have exceeded the
> 84
> (whatever) limit to the number of databases instances that can be open at
> one time??  I solved the problem by appending the results of each of the 6
> queries to a temp table and using the table for the report.
>
> T. Septav
> Nanaimo, BC
> Canada
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>