> >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: 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/5.2.1.1.1.20120824223342.01fbfe60@POP-Server.stny.rr.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.