By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,661 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

data has been changed error message

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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?
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.