The data has been changed

  • Thread starter Thread starter mattieflo
  • Start date Start date
M

mattieflo

Good morning,

I have a database front end used by mulitple users that contains a
continuous form. On this form is a drop down box and when a user selects an
option out of this drop down box, some times they get a "The data has been
changed" message. There really is no code behind the scenes for this form. In
broad terms, does anyone know what I should be looking for when
troubleshooting this? I'm not sure where to begin. The lock property on the
form is set to "neither", btw.
 
The way you describe it it looks like a concurrency problem. Someone might be
using the same record at that particular time. Try investigating when this
situation occurs. Maybe it's also an option to set the recordlocking to true.

hth
 
Hi Maurice,

I took a look at this myself and the users are not on the same record. They
both have the form up and for one of the combo boxes they are getting that
message. I've yet to try your 2nd suggestion but i'll give that a look when I
get a chance. Thanks for your reply!

Matt
 
Hi Ling,

To my knowledge everyone is copying and pasting the front end to their
desktop.
 
Back
Top