Write conflict with just one user? 1

[Jedi420]

I have a project database that I am currently developing. Sometimes (I can't even pinpoint what I do to make it happen) when I am testing out the database (I am the only user at the time) I will get a write conflict after making a field selection/change or selecting a subform. It says:

This record has been changed by another user since you started editing it. If you save the record ..... blah blah

In the end, this is intended to be a multi-user DB. It's already split and has edited record locking (could that be it? But I need it) enabled. The error seems to just pop up randomly, but I'm sure there's a very good (or bad) reason why it's happening. Any advice or suggestions would be greatly appreciated. Thanks! (^_^)

-Jedi420

 

[stvnkrs]

I have the same problem! Help!

 

[willir]

Jedi420

A simple question... Do you have two sessions of Access running?

 

[Jedi420]

My problem was solved a whiles back by searching through other threads. What's usually happening here is that you are updating records through a form (bound forms) and through code (like some code that alters records on a combo box afterupdate). Try to see if theres anywhere in your operations that have record altering code right after you can update a record through the form.


-Jedi420

A man who has risked his life knows that careers are worthless, and a man who will not risk his career has a worthless life.

 

[romanzero]

Hi,

I've been dealing with this issue for months! Jedi is correct, it has to do with bound forms.

Only last week was I able to find the VBA code that was causing my record to get the Write Conflict.

This might not be the solution for your problem, but you might want to look at the "On Current" actions in VBA. If some code there is changing a field from the table that is the source for your Primary Form this will trigger the error message.

Hope this helps.

 

[willir]

Jedi420
Yep -- that would do it.