>Some very good info. Thanks very much Bob.
>
>On the SQL 7.0 issue, do you mean that I can have a remote view of a SQL 7.0 table and issue a record lock on the base table?

You would probably have to send the lock command with the SQLExec() function (SQL Pass Thru) to the server. I doubt remote view would implment this, since it is back end specific.

BOb