Hi Brad,
>If I try to pack the table I get the error message "File is open in another work area". Am I going about this the wrong way using the isexclusive() function? How can I tell when it's safe to pack the table?
Even if you open a table exclusive you can open it several times in the same datasession on the same computer. Instead you could loop through all open tables (AUSED tells you about them) and compare the table name and path with the one you want to pack. In the case of the SELECT statement you could also add a NOFILTER clause to it which would force VFP to create a new phyiscal cursor that is indpendant from the original table.
Christof
--
Christof