Don't waste time looking for the problem.

Just emit a SET Database TO and  CLOSE TABLES ALL .

After that execute your routine.

E.

>________________________________

> From: Peter Hart <PHart@peterhartcomputers.co.uk>

>To: "'profox@leafe.com'" <profox@leafe.com>

>Sent: Friday, August 24, 2012 5:11 PM

>Subject: Tables left open when form closes

>

>I have an application which uses Arg Software Ribbon bars.

>

>When I click on an icon to open a form which needs to open a table exclusive i.e. for re-indexing. I get an error that the table is already in use. I don't get this error if either this is the first form opened or I have only opened forms that don't use that particular table.

>If I open FoxPro whilst the application is open I can see which tables have been used by trying to open the tables exclusive, and the I get the error.

>All the forms are based on a form class that has its datasession property set private.  I thought these would automatically close any tables opened by the form as the form was closed.

>

>Any ideas were I am going wrong?

>

>Is it possible to run through all used work areas to see if the tables required are in use and if so close them?

>

>T.I.A.

>

>Peter

>Peter Hart Computers

>

>

>

>

>--- StripMime Report -- processed MIME parts ---

>multipart/alternative

>  text/plain (text body -- kept)

>  text/html

>---

>

>_______________________________________________

>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/9C476F6427FC3547AC8BBFE5E254EC56538C4F2627@SERVER.peterhartcomput.local

>** 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.

>

>

>

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

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/1345842347.81684.YahooMailNeo@web140606.mail.bf1.yahoo.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.