>
Rick,
>You could try to fopen() file for RW access. It's silent and doesn't produce error. If you cannot get a positive handle number than it's in use.
>
lnHandle = fopen(myTableName,12)
>if lnHandle < 0
> * ....
>else
> =fclose(lnHandle)
> use (myTableName) exclusive
>endif
To be more precise and take into account that someone could open it between the few milliseconds (fclose - use) you could set a flag that you're going to get it exclusive to notify other users (ie:write a dummy txt file and check its existence).
>Cetin
There is a flaw with this method. Between the time you do the fclose and the USE, someone else can open the table. The only way to be absolutely sure is to try to USE the table EXCLUSIVE and trap the error if you can't get it.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer