>>>I want to simulate two users access the same table on my PC, i.e. open the same table in two instances of VFP 7. Can this be done.
>>
>>Absolutely - as long as neither is opening the table exclusively.
>>
>>Alan
>
>Thanks, I did the following
>
>open database dbcname shared
>use tablename in 0 shared
>
>in both instances, then I check result of rlock(tablename), in second instance get .f. if on the same record, .t. if on different record (as expected).
>
>Question does tableupdate work the same way?
It should. If one user has the record locked, the other user won't be able to update it, but as far as I know, tableupdate() itself only locks the record long enough to write it out.
Make sure you read up on CurVal() and OldVal() in the help to get a better idea of how to handle table updates on multiuser systems.
Alan