Question Locked
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Every so often, my database and/or VB code gets a concurrency exception when I try to write to the database. If I alter the code using the acceptChanges method on the dataset, I eliminate the exception, but the database is not being updated. It seems that the data is being locked up somehow. This happens even when I'm the only one on the system. Can anyone help???
2 replies
by vlenza Accepted solution
Clarifications
by tony hopkinson Accepted solution
when the record to be updated is not unique, or can no longer be found.
A concurrency conflict is not a lock. It's saying the record I got when the dataset was opened can not be found when writing the changes.
Do all the tables have a primary key?
Have you opened that data twice, then updated from one recordset, and then updatning from another?
Some of the stuff in here might help to identify what's going on if you have.
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending
0 helpful
15 replies
Question
Is WSL still relevant in 2026?
0 helpful
1 reply
0 helpful
2 replies
0 helpful
10 replies
Question Unanswered
i need help in transferring my bulk emlx files
0 helpful
0 replies