The data has been changed

[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.

 

[Maurice]

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

 

[mattieflo]

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

 

[Linq Adams via AccessMonster.com]

"I have a database front end used by mulitple users that contains a
continuous form."

This statement makes me wonder about exactly how you have this set up. When
using a split database, there should be a *copy* of the front end installed
on each user's PC. In other words, multiple users should not be using *a
front end* but rather a copy of the front end. IF you have this set up where
users are sharing a front end, this may be the root of your problem. Shared
front ends have also been given as a common cause of repeated corruption.

 

[mattieflo]

Hi Ling,

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