I am unsure whether my problem is an issue of using tables or using SCAN (or worse still, Both!). I am opening a table (though it happens with several other tables) and then scanning it. I know the SCAN in itself works, as I have tried the code elsewhere. I have just done a similar scan on another table (included in the dataenvironment) in code a few lines earlier that works fine. I tried including and excluding the table from the dataenvironment, with the following results:

1. Problem_Table Not included in Form dataenvironment
USE Problem_Table
SCAN FOR Problem_Table.field = cVARIABLE

> Error “Table not marked belonging to dB. Create Backlink?”

2. Problem_Table Added to Form dataenvironment
*USE Problem_Table
SCAN FOR Problem_Table.field = cVARIABLE

> Nothing found by SCAN

I have played around with EXCLUSIVE settings (at one point I got a "Must be opened exclusive" error; opening table AGAIN ; tables appear to have the same properties – checked Status of environment with DISPLAY STATUS; Validated dB; the problem table works fine in another form; Removed & added table; DISPLAY DATABASE shows accurate info; Table and database are in standard folders (ie no need for Stonefield).

Any help greatly appreciated.
Cheers,
Blair