Hi Jimi,

Try something like:

LOCAL cErrorHandler

* ----- Store the current error handler
cErrorHandler = ON("error")

* ----- Turn Error Handler off
ON ERROR *

* ----- Attempt exclusive open
SELECT 0
USE mytable EXCLUSIVE

* ---- Reset error handler
ON ERROR &cErrorHandler

IF NOT USED("mytable")
    * ----- File wasn't opened
    *       Add appropriate code here
ELSE
    * ----- File opened exclusively
    *       Add appropriate code here
ENDIF

Hope this helps,
Gavin...

>I wanan update the content of a table in my program, before saving of course I have to check if any other is using the table, so i tried to use the example from MSDN about IsExclusive..
>
>my program:
>1: set exclusive off
>2: open in 0 exclusive
>3: if IsExclusive() then
>4: **do the updates here**
>5: else
>6: **prompt error message**
>7: endif
>
>To test the program, I open the database exclusively in another program, and then run the above code. A "access denied" message pops up at line 2.
>
>So what should I do, if I wanna ensure there's no one using the table, and then update it?
>
>Thanks for any help in advance!