On 9/7/2011 11:40 AM, Kent Belan wrote: > Hello Mike, > > On startup, there are 45 free tables opened. > > The mini-close routine closes 9 of the most used tables and reopens them. > > We have options to do a full close, mini close or nothing and leave the > tables open. > > The full close takes too long, so that is the reason for the mini-close.
So closing them and reopening them basically gets you a "fresh" handle and avoids your program encountering the Error 1104? Interesting... -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4e6793f7.4080...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.