Another User trying to make changes

J

jnh11

Getting error 'Another user trying to make changes' when attempting to update
data. Note that this is a single user NOT networked PC. Any ideas ? Thanks
 
A

Albert D. Kallal

jnh11 said:
Getting error 'Another user trying to make changes' when attempting to
update
data. Note that this is a single user NOT networked PC. Any ideas ? Thanks
Click to expand...


What the above means that you have form, some data been changed, but it not
yet been committed back tot he disk drive.

Now, if another user, (or your code) modifies the underlying data set, then
the pending data been changed!!

So, that other user is likely your code. (ms-access can't tell if it is you,
your code, or another person that modified the data...all it can know is
that the data record been changed....

the simply solute is to force a disk write BEFORE you run some sql update
code, or launch another form that can potential modify the same forms
record..


Just add

if me.Dirty = true then
me.Dirty = false
end if

' ...you update code goes here, or code that launches another form.....
 
Top