>Hi Martineau,
>
>>I have to open a table exclusive how can i verify if the table is not open by the other application.
>>Use Table In 0 Exlusive
>>a message box tel me that the table is use
>
>Do this:
>
>
lcError = on('error')
>on error *
>
>use .. excl
>
>on error &lcError
Now USED('table') will tell you if you were succesful or not. If this seems cumbersome, try to make it a reusable method.
Just to explain this idea a bit. The only way to make sure you get exclusive use of a table is to try to USE EXCLUSIVE and then have the error handler fire if you can't get it or do as Mike suggested.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer