> >Is it possible to run through all used work areas to see if the tables > >required are in use and if so close them? > >
>You can use AUSED(), you may need to use SET DATASESSION also. You can use ASESSIONS() to get an array of data session IDs, and then loop through those, use AUSED() to get an array of work areas in each data session, and close them. But in many situations I like Eurico's suggestion better: CLOSE TABLES ALL CLOSE DATABASES ALL Then OPEN DATABASE MyDatabase SET DATABASE TO MyDatabase Then back to what you were doing. Ken Dibble www.stic-cil.org _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
