Prompted with message that data has changed... ?

[hzgt9b]

I am building an MS Access 2003 form that has a series of controls on it.
Under each control is some code that, among other things, keep track of which
control is activated on the form. (Because of project constraints, only one
control is enabled at a time to ensure that tasks are performed in the
correct order). Status information and a list of active controls are stored
in a coupld of tables taht are updated though some public module code.

All that said, I am getting an error message that I'm unsure about as I test
my form. The message is:

The data has been changed. Another user edited this record and save the
changes begore you attempted to save your changes. Re-edit the record.

Since this access sb is on a machine that has its network cable unplugged I
find it hard to believe that another user has accessed the mdb I'm working
on... any idea as to the source of the error message?

 

[Aaron G]

I've gotten that error before while working on a db that I know I'm the only
who accessed it. I've always assumed and treated it like it was an Access
bug (something to do with the lock record, I assume). I always do a restart
of the db just to be sure the lock record is reset.

HTH

Aaron G
Philadelphia, PA

 

[Chris]

Hi

I have had this problem in the past whereby I have invoked a function that
updates the record I currently have in focus. Then when you come to leave the
record you get the message.

In these cases, I save the current record, prior to calling the function and
ensuring that there are no more updates done on the form after the function
has run (e.g. call the function just prior to leaving the record)