>Hi,
>
>The only way I know how to determine if a table is already open under some unknown alias is by trying to open the table exclusive and catching the error. Is there another way, maybe simpler?
>
>TIA.
TRY
USE YourTable IN 0 EXCLUSIVE
CATCH
MessageBox("The Table is already opened somewhere")
ENDTRY
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.