Queries/Tables open limit

  • Thread starter Thread starter Trevor Bourne
  • Start date Start date
T

Trevor Bourne

I am designing an application which uses a form
containing many subforms - each subform is bound to a
separate query. I am now getting a runtime error 'cannot
open any more tables'. Help says I have exceeded the
number of tables which can be open. Can anyone please
tell me what that limit is ?
 
I think the message is a Red Herring or White Elephant. It is not uncommon
to get an error message that really isn't the cause of the problem.

Sometimes trying to load all the data at once can be problematic, slow if
nothing else. Visit the following article:
http://doc.advisor.com/Articles.nsf/nl/12834
It discusses late-binding the subform, such that there isn't a load hit for
each one. Also, if you really are hitting the limit, it is less likely to
happen, unless the user's visit EVERY subform on the entire form.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Steve

Many thanks for your response. Further searches in Help
discovered that the limit on open tables is over 1000 and
so the error is obviously misleading. Looking for other
possible causes now.
 
Back
Top