B
Bea
Hello,
I use Access form1 to insert data into a table residing in SQL2k.
When I use form2 to update the already saved data and 'SAVE' is executed, a
window pops up stating that an other user has changed the data and suggests
to save the changes in the Notepad for later view. But, it doesn't save it
to the server.
Saving new data into a new row as I said, works fine; it only happens when
I'm
modifying the already saved data.
Using UPDATE in the SQL Analyzer works fine.
The CustomerID is set as Primary and Indexed and there're no other users.
Can someone help?
TIA
Bea
I use Access form1 to insert data into a table residing in SQL2k.
When I use form2 to update the already saved data and 'SAVE' is executed, a
window pops up stating that an other user has changed the data and suggests
to save the changes in the Notepad for later view. But, it doesn't save it
to the server.
Saving new data into a new row as I said, works fine; it only happens when
I'm
modifying the already saved data.
Using UPDATE in the SQL Analyzer works fine.
The CustomerID is set as Primary and Indexed and there're no other users.
Can someone help?
TIA
Bea