An error handler is the only way to be sure. On a busy network, someone else can get the table between FOPEN and USE.
>Thank you both for the suggestions. I'll give them a try.
>
>I'm hoping that with FOPEN(), I can simply check FERROR() and not have to do anything with ON ERROR.
>
>>Try to open the dbf using FOPEN(), check what FERROR() returns, if it returns "Access Denied", the file is open somewhere.
>>
>>>Hi All,
>>>
>>>Is there a way to determine if a table is being used in a different datasession without having to loop thru all datasessions and checking with USED()?
>>>
>>>TIA
>>>
>>>Mike
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer