[AccessD] Advice on A2010....

Thanks guys.  That is the angle I am taking.  Even though I have worked on databases with many more bound controls et al, it seems this is the most likely suspect for these issues. Going to unbound everything and use value only lists in the list boxes. Luckily I have all code to do this fairly quickly.  Should only take a couple of days.

Will let you know how it goes.

Cheers
d

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, 8 December 2011 12:03 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Advice on A2010....

Too many open connections with all of those listboxes and subforms?


On 7 Dec 2011 at 23:33, Darryl Collins wrote:
> 
> The only thing that is unusual for me is I have one main form, which 
> has 37 tabs on it which in turn has listboxes and subforms - and the 
> subforms are bound to their tables - I would usually use unbound, but 
> in this case there is no point.  Besides they are all really small 
> datasets.
> 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com