data has been changed error message

[Terri]

I'm getting the error message "The data has been changed. Another user
edited this record and saved the changes before you attempted to save your
changes. Re-edit the record"

This is the code that is causing this on the Before Update event.

Me.ModifyUser = Forms!frmswitchboard.UserName
Me.ModifyDateTime = Now()

I am trying to audit when the data on the form has changed and who changed
it.

Any ideas?

Access 2002 mdb with linked tables to SQL Server 2000

[Steve Jorgensen]

On Fri, 11 Nov 2005 15:49:33 -0700, "Terri" <te***@cybernets.com> wrote:

I'm getting the error message "The data has been changed. Another user
edited this record and saved the changes before you attempted to save your
changes. Re-edit the record"

This is the code that is causing this on the Before Update event.

Me.ModifyUser = Forms!frmswitchboard.UserName
Me.ModifyDateTime = Now()

I am trying to audit when the data on the form has changed and who changed
it.

Any ideas?

Access 2002 mdb with linked tables to SQL Server 2000

Are you sure that code is the cause? What happens when you comment that code
out?

[MacDermott]

I've had better luck using AfterUpdate than BeforeUpdate for such purposes.

"Terri" <te***@cybernets.com> wrote in message
news:dl**********@reader2.nmix.net...

I'm getting the error message "The data has been changed. Another user
edited this record and saved the changes before you attempted to save your
changes. Re-edit the record"

This is the code that is causing this on the Before Update event.

Me.ModifyUser = Forms!frmswitchboard.UserName
Me.ModifyDateTime = Now()

I am trying to audit when the data on the form has changed and who changed
it.

Any ideas?

Access 2002 mdb with linked tables to SQL Server 2000

[Rick Brandt]

MacDermott wrote:

I've had better luck using AfterUpdate than BeforeUpdate for such
purposes.

Why? If you change a record in the AfterUpdate then you trigger another update.
I'm not sure you wouldn't be trapped in a loop were you to do that.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com