Write Conflict

[Guest]

I've added a new field to a SQL linked table and added the field to a form.
When I attempt to enter data to this or any other field and save or move to a
new record, am told someone else has edited this record. I am not given the
option to save, only to discard or copy to clipboard. What is causing this
error? Only one form is being used.

 

[TC]

Are you saying that this didn't happen before, and now it does, and the
/only change/ that you have made, is to add the new field? IOW, did you
do anything else at the same time, that you added the new field?

Does it still happen if you temporarily remove the new field from the
form? from the table?

TC [MVP Access]

 

[Guest]

That's correct. Did not happen before. I added the field to the form and
could not save any new changes due to write conflict. I removed the field
and the write conflict remained. I went directly to the table (still in
Access) and could not save any changes there either. This is not a SQL
server issue as I can save changes when writing to the table directly
(Enterprise Mgr).

Any thoughts?

 

[TC]

You've said that it worked ok before you added the field to the table
and to the form. But it kept happening, even after you removed the
field from the form (but not fom the table). So the logical conclusion
is, that the problem was caused just by adding the field to the table.
That seems unlikely to me, so I suspect that you must have done
something /more/ than just adding the field to the table & form.

Did you write any new code at the same time? If so, does the problem
still happen if you suppress that code?

The error in question, normally means that the form, /and your code/,
have tried to update the same record at the same time. Access often
sees this as two different users conflicting, trying to change the same
record at the same time.

HTH,
TC [MVP Access]

 

[Guest]

I suspected the problem might be with the code. I'm working on making some
updates to a mdb that I didn't create so I'm unfamiliar with the code. Also,
I'm not very comfortable with coding in Access and do most of my work via
macros. Is there any way to debug this in Access. That is, how can I find
the code that is causing the problem. Again, I didn't add any code myself.

Also, here is the progression of what I did:
Add field to SQL table on server.
Update link to table. (Data still updateable through form)
Add field to form. Save and close form. Reopen (Write Conflict appears)
Remove field from form. (Write Conflict remains)