|
-
June 23rd, 2009, 10:32 AM
#1
[RESOLVED] OleDB Concurrency Violation in MS access
Hi friends !
I have a strange error when updating my database
Database: MS access
I'm using DataTable, DataAdapter and there is no other user who is able to access the database as it is stand alone on my laptop.
I'm adding some DataRows and that works fine so after I have added them to the database using DataAdapter and Insert Command I'm using myTable.AcceptChanges() so the table knows this are the actual recods now.
The table is offline and only filled when starting the program and the DataAdapter is used to update the real database when changes occur.
Now if i do some changes on that just added data and I want to write this changes back to the database I'm getting an error
'Concurrency Violation' which normally only should occur if some others access my database, isn't it ?
If I'm cloing program and reopening it, so I'll get all the added recods read in again into my table and I'm doing the changes after that, then it ll woks properly.
Any one knows what's I'm doing wrong?
 Jonny Poet
To be Alive is depending on the willingsness to help others and also to permit others to help you. So lets be alive. !
Using Code Tags makes the difference: Code is easier to read, so its easier to help. Do it like this: [CODE] Put Your Code here [/code]
If anyone felt he has got help, show it in rating the post.
Also dont forget to set a post which is fully answered to 'resolved'. For more details look to FAQ's about Forum Usage. BTW I'm using Framework 3.5 and you ?
My latest articles :
Creating a Dockable Panel-Controlmanager Using C#, Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 | Part 7
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
