I have an Access 2000 database that I am developing, with a SQL server 2000 back end. Randomly, whenever I'm entering data into the table or moving from one record to the next, I recieve an error saying,
"The Data has been changed.
Another user edited this record and saved the changes before you attemped to save your changes."
Since this is still in development there is obviously no one else in the database.
I do have a trigger defined on the table that could be causing the problem:
CREATE TRIGGER TR_OfficeLocs_Update
ON db
fficeLocs
FOR UPDATE
AS
set nocount on
UPDATE OfficeLocs
SET ModUsr = SUSER_SNAME(), ModDate = GETDATE()
I'm still relatively new to using SQL server. The weird thing is that it doesn't happen every single time. Any tips, or things I should check out? Thanks!
"The Data has been changed.
Another user edited this record and saved the changes before you attemped to save your changes."
Since this is still in development there is obviously no one else in the database.
I do have a trigger defined on the table that could be causing the problem:
CREATE TRIGGER TR_OfficeLocs_Update
ON db
fficeLocs FOR UPDATE
AS
set nocount on
UPDATE OfficeLocs
SET ModUsr = SUSER_SNAME(), ModDate = GETDATE()
I'm still relatively new to using SQL server. The weird thing is that it doesn't happen every single time. Any tips, or things I should check out? Thanks!