Jim Dettman
jimdettman at verizon.net
Sat Apr 23 17:53:33 CDT 2011
2048 is the table ID limit. While that sounds like a lot, every field reference carries a table I'd reference. Jim Sent from my iPhone On Apr 23, 2011, at 5:55 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote: > 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 >> > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com