SNIP

Neil,

As Jon said, you don't need the SET EXCLUSIVE OFF if you specifically open the table SHARED.

In addition, change your USED test to something like this:

IF USED("UserLog")
   SELECT UserLog
ELSE
   USE UserLog IN 0 SHARED
ENDIF

UPDATE

Above code will still leave you in the wrong work area. Try this:

IF !USED("UserLog")
   USE UserLog IN 0 SHARED
ENDIF
SELECT UserLog

HTH,