Record Locking Issuse

  • Thread starter Thread starter Synergy Tooling Systems
  • Start date Start date
S

Synergy Tooling Systems

This is a new problem that just cropped up. The front end is Access200, the
back end SQL Server on Win2000 server.

Message is:

This record has been changed by another user since you started editing it.
If you save the record, you will overwrite the changes the other user made.
Copying the changes to the clipboard will let you look at the values the
other user entered, and then paste your changes back in if you decide to
make changes.


Two users are having this issue and I encountered a couple times in in
development the other day. It seems like I fix one problem and another pops
up to replace it. I hope someone can help me.

Synergy
 
This is a new problem that just cropped up. The front end is
Access200, the back end SQL Server on Win2000 server.

Message is:

This record has been changed by another user since you started editing
it. If you save the record, you will overwrite the changes the other
user made. Copying the changes to the clipboard will let you look at
the values the other user entered, and then paste your changes back in
if you decide to make changes.


Two users are having this issue and I encountered a couple times in in
development the other day. It seems like I fix one problem and
another pops up to replace it. I hope someone can help me.

Synergy
Click to expand...
I'm no expert but I sprinkle requery commands everywhere like
Forms.FrmOrder.Requery
DoCmd.Requery
Field.Requery
This has prevented a few record lock errors I have run into. I must admit
I have never seen your error but then I have never used an SQL server.
Good luck. I know how frustrating these errors can be
Bob
 
Hello Bob,

I had tried requerying all over the place. I finally used Me.Refresh in a
couple of selected procedures to solve another issue, which seems to have
cleared this one up as well.

Thanks for the feedback.
 
Back
Top