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

Getting a "bogus" "The data has been changed" message from Access 2003

P: n/a
PW
Hi,

I have a form with unbound fields on it. The user selects a record
from a recordset and I populate the unbound fields. When I try to
change the unbound quantity text box, Access 2003 tells me "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 does not always happen. And yes, I can re-edit the quantity text
box. This is BS because there are no other users. It is only me that
is testing my new form on my PC only!!

Any ideas what is causing the message and how I can get stop it from
displaying?

-paul
Oct 25 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
the form notices that you are changing the recordset behind it's back.
Try a docmd.runcommand accmdsaverecord, or an undo before you do any of
the manipulation to avoid that error.
PW wrote:
Hi,

I have a form with unbound fields on it. The user selects a record
from a recordset and I populate the unbound fields. When I try to
change the unbound quantity text box, Access 2003 tells me "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 does not always happen. And yes, I can re-edit the quantity text
box. This is BS because there are no other users. It is only me that
is testing my new form on my PC only!!

Any ideas what is causing the message and how I can get stop it from
displaying?

-paul
Oct 25 '06 #2

P: n/a
This does not always happen. And yes, I can re-edit the quantity text
box. This is BS because there are no other users. It is only me that
is testing my new form on my PC only!!

Any ideas what is causing the message and how I can get stop it from
displaying?

I just posted a similar complaint a few days ago.

"Write Conflict Message - Turn Off!"
http://groups.google.com/group/comp....6dfba800216ef0

Unfortuantely - this seems to be blatant and obvious control mongering
by some know-it-all Access developer (yes, I'm now baiting
whoever-it-is into a fight).

To get past it I just used update queries - since no one who read my
post could tell me what was wrong.

BTW, make sure you turn off (uncheck) Tools/Options-Edit/Find
(Edit/Find for god's sake??) - Confirm - Action Queries.

Store a value - get an error. Whether it's directly to a table or to a
form control doesn't seem to matter.

This sucks.
Christian

Oct 25 '06 #3

P: n/a

Paul

I'm not entirely sure I understand the exact scenario (Are the unbound
fields from the same recordset as the bound? How are you saving the
changes to the unbound?)

But, when I've this error, I've had good luck with adding a timestamp
column to the table
On Wed, 25 Oct 2006 13:52:12 -0600, PW
<pa********@removewilliamsonenterprises.comwrote :
>Hi,

I have a form with unbound fields on it. The user selects a record
from a recordset and I populate the unbound fields. When I try to
change the unbound quantity text box, Access 2003 tells me "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 does not always happen. And yes, I can re-edit the quantity text
box. This is BS because there are no other users. It is only me that
is testing my new form on my PC only!!

Any ideas what is causing the message and how I can get stop it from
displaying?

-paul
Oct 25 '06 #4

P: n/a
PW
On Wed, 25 Oct 2006 18:40:12 -0500, Magenta <cl****@comcast.net>
wrote:
>
Paul

I'm not entirely sure I understand the exact scenario (Are the unbound
fields from the same recordset as the bound?
No, they are just unbound text and combo boxes. I have a detail
section (in a Continuous Form) that has the bound fields. When a user
selects a row I have an edit button, that when clicked, I manually
populate them from the recordset. It is only the quantity field that
is giving me this error. There is code in the AfterUpdate of the
quantity text box but it will not get run because blnInEditMode_pw
gets set to True when the user clicks the Edit button:

If Me.txtQuantity_pw 0 And Not blnInEditMode_pw Then
Me.txtTax_pw = (((Nz(Me.cboItemNo_pw.Column(5), 0)) *
Me.txtQuantity_pw) * Me.txtPrice_pw)
End If

When I bring up a record and populate the unbound fields, then I
select a different item number from it's combobox I set the unbound
quantity combobox to zero. As soon as I try to change the quantity is
when I get that multi-user message.
How are you saving the changes to the unbound?)
For a record being edited:

strFind_pw = "purchaseid = " & intPurchaseID_pw

rstPurchases_pw.FindFirst strFind_pw

If Not rstPurchases_pw.NoMatch Then

.Edit

!Purchaser = Me.cboEmployee_pw
!Name = Me.cboEmployee_pw.Column(0)
!InventoryType = "S"
!PurchaserType = "E"
!Date = Me.txtDate_pw
!InventoryID = Me.cboItemNo_pw.Column(4)
!Price = Me.txtPrice_pw
!Quantity = Me.txtQuantity_pw
!Tax = Me.txtTax_pw
!SoldBy = Me.cboSoldBy_pw

.Update

End If

>
But, when I've this error, I've had good luck with adding a timestamp
column to the table
I will try that!! Thanks!

Guess what? I rebooted and I am not getting that message any more (so
far)!

-paul w
>
On Wed, 25 Oct 2006 13:52:12 -0600, PW
<pa********@removewilliamsonenterprises.comwrot e:
>>Hi,

I have a form with unbound fields on it. The user selects a record
from a recordset and I populate the unbound fields. When I try to
change the unbound quantity text box, Access 2003 tells me "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 does not always happen. And yes, I can re-edit the quantity text
box. This is BS because there are no other users. It is only me that
is testing my new form on my PC only!!

Any ideas what is causing the message and how I can get stop it from
displaying?

-paul
Oct 26 '06 #5

P: n/a
PW
On 25 Oct 2006 15:23:23 -0700, "Pachydermitis" <pr*******@gmail.com>
wrote:
>the form notices that you are changing the recordset behind it's back.
Try a docmd.runcommand accmdsaverecord, or an undo before you do any of
the manipulation to avoid that error.
Will do! Thanks
>PW wrote:
>Hi,

I have a form with unbound fields on it. The user selects a record
from a recordset and I populate the unbound fields. When I try to
change the unbound quantity text box, Access 2003 tells me "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 does not always happen. And yes, I can re-edit the quantity text
box. This is BS because there are no other users. It is only me that
is testing my new form on my PC only!!

Any ideas what is causing the message and how I can get stop it from
displaying?

-paul
Oct 26 '06 #6

P: n/a
PW
On 25 Oct 2006 15:23:23 -0700, "Pachydermitis" <pr*******@gmail.com>
wrote:
>the form notices that you are changing the recordset behind it's back.
Try a docmd.runcommand accmdsaverecord, or an undo before you do any of
the manipulation to avoid that error.
PW wrote:
Rats acccmdsaverecord didn't stop it and an undo caused "undo isn't
available at this time"

>Hi,

I have a form with unbound fields on it. The user selects a record
from a recordset and I populate the unbound fields. When I try to
change the unbound quantity text box, Access 2003 tells me "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 does not always happen. And yes, I can re-edit the quantity text
box. This is BS because there are no other users. It is only me that
is testing my new form on my PC only!!

Any ideas what is causing the message and how I can get stop it from
displaying?

-paul
Oct 26 '06 #7

P: n/a
PW
I think I fixed it! I requiried the form and that seems to have done
the trick! I googled this newsgroup and found this post which
explains why it works (although the quantity field on my form is
unbound!):

From: Tom Heliotis - view profile
Date: Tues, May 28 2002 11:15 pm
Email: t...@heliotis.net (Tom Heliotis)
Groups: comp.databases.ms-access
Not yet rated
Rating:
show options
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse | Find messages by this author

Rosemary,

The requery did the trick.

What I now understand is that "The data has been changed" doesn't
necessarily mean the the data in the database has been changed, (that
happens all the time), it's that the data in the database changed and
is now different than the data on the screen. So ... I guess whenever
you change the data in the database you have to do something to make
sure the bound fields on your screen also match, or you will get "The
data has been changed" next time you try to edit. The easiest way to
do that is Me.Requery

Thanks to the people who posted answers!

- Hide quoted text -
On Wed, 25 Oct 2006 13:52:12 -0600, PW
<pa********@removewilliamsonenterprises.comwrote :
>Hi,

I have a form with unbound fields on it. The user selects a record
from a recordset and I populate the unbound fields. When I try to
change the unbound quantity text box, Access 2003 tells me "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 does not always happen. And yes, I can re-edit the quantity text
box. This is BS because there are no other users. It is only me that
is testing my new form on my PC only!!

Any ideas what is causing the message and how I can get stop it from
displaying?

-paul
Oct 26 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.