HI All.

i'm building a project in VFP8 with SQL Server using CursorAdapter.

for this purpose i've build a Custom DataEnvironment and CursorAdapter Class and on a Single FORM(MainForm) which is always active throughout the life of the application i've put the DE Class with CA Class for every table in SQL Server and opening all the tables once when application loads itself. I've a Custom MainForm method RefreshCA()
and in this method all the tables are refreshed by using CursorRefresh() method of CA.

now the problem i'm facing is in the multiuser environment, on the refreshing of data, suppose there are 2 users using my application USER1 and USER2, now User1 has updated a table and by using MainForm.RefreshCA() all Cursors are refreshed for USER1 but on the other side for USER2 there is no effect on his cursors, so i need suggestions and solution to overcome this problem

Regards
Anwar