Hi Cemal,

Since you are using MS SQL as backend database, you can create remote view of your table from SQL Server in VFP. Use the remote view as your data source in your VFP DataEnvironment and buffer it with "Pessimistic Buffering". To have more information about Remote View and Buffering see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dgtskAccessingRemoteData.asp and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgtskBufferingData.asp.

Rene

I need help about locking and unlocking records,prevent a user to open a record or recordset that is opened by another user.
Thanks