Stuart McLachlan
stuart at lexacorp.com.pg
Sat Apr 23 16:55:17 CDT 2011
>From everything that I have read, Access maintains TableIDs internally and the number currently used is not exposed in any way, so sadly it appears that the answer to your question is - You can't. -- Stuart On 23 Apr 2011 at 5:20, Darrell Burns wrote: > Howdy. First-time on AccessD. > > I've tried all the other forums and can't get an answer to this one. > > I have a FE A2007 app linked to a BE A2007 database. There's a master > form with 6 tabs. Each tab contains a subform that's bound to a query. > Plus I open recordsets on the the BE tables to fetch stuff for the > form. You can drill down from any subform to a detailed form by > double-clicking a data field. I started getting the above error > message after opening 2 or 3 of these forms, so I created a form > handler method that shuts down the calling form and closes all the DB > connections before opening the target form. I'm still getting that > error. I've gone thru my code and diligently set all DBs to nothing at > the end of each sub, but I can't seem to lick the problem. > > > > Suggestions from other forums have been to unbind the tables from the > subforms. I buy that, but the question I can't get an answer to is how > can I monitor how many connections I have open at one time so I can > diagnose the problem? I feel like I'm debugging in the dark. > > > > Please turn on the light for me. > > > > Thanx, > > Darrell > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >