Maybe something like this:

lUsed = .F.
AUSED(laTables)
FOR x = 1 to ALEN(laTables,1)
   If 'EMPLOYEE' $ DBF(laTables[x,2])
      lUsed = .T.
   Endif
Endfor
? lUsed

Alan


>Using VFP8, is there a way to tell if a table is in use if that table was opened with a different alias?
>
>For example:
>**************************
>USE employee IN 0 ALIAS emp &&This is OK.
>
>***However, later on in the application...
>IF !USED("employee") &&This will return TRUE.
> USE employee IN 0 &&This would result in a File In Use error.
>ENDIF
>SELECT employee &&This would also error.
>**************************
>
>I know this isn't the best practice but how could I tell if employee is already in use in the current data session?
>
>Thanks,
>
>Jerry