Thanks, this is the sort of solution I came up with using the new TRY, CATCH features.

I was just wondering if there was another way.

Thanks,

Jerry



>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