Z
Zlatko
There is a bound form for data input in Access Project (Access front-end
with SQL Server), which is based on a strored procedure (in-line function)
that queries several joined tables. It is "updatable snapshot".
Inside the form there are 5 columns (fields) for data input while other
fields are write protected. Data input in those 5 fields work fine if I
input row by row.
But, if I go to other rows and then I go back to previous rows to change
somethnig, a message "Write conflict" apears telling that an another user
made changes. Then I have to choose between "Save changes", "Drop changes"
and "Copy to clipboard".
What is the reason for this problem, and how to solve it?
I suppose that I have to do something with properties "Got focus" or "Lost
focus"?
Thanks.
Zlatko
with SQL Server), which is based on a strored procedure (in-line function)
that queries several joined tables. It is "updatable snapshot".
Inside the form there are 5 columns (fields) for data input while other
fields are write protected. Data input in those 5 fields work fine if I
input row by row.
But, if I go to other rows and then I go back to previous rows to change
somethnig, a message "Write conflict" apears telling that an another user
made changes. Then I have to choose between "Save changes", "Drop changes"
and "Copy to clipboard".
What is the reason for this problem, and how to solve it?
I suppose that I have to do something with properties "Got focus" or "Lost
focus"?
Thanks.
Zlatko