MS Access concurrency exception

[Charlie Williams]

I am having difficulty performing updates and deletions
on an Access database using the Update() method of the
OleDBDataAdapte r. I can insert rows without a problem,
but I get a concurrency exception when trying to update
or delete.

I am quite sure that no concurrency conflicts actually
exist. Is there a reason why the data adapter I am using
may have a different row version that the database that
it got its data from?

I can work around the problem by removing the concurrency
check from the update command, but would rather not
remove checking all together, for obvious reasons.

Has anybody experienced a similar problem with MS Access?

Thank you for any help.

P.S. The exact same code works flawlessly with SQL
Server, but I can't use it in this particular situation.

[Charlie Williams]

Just to illistrate my point, I created a new project and
included this code:

DataTable dt = new DataTable();
oleDbDataAdapte r1.Fill(dt);
dt.Rows[5]["Superintendent "] = "Craig Birch";
try{
oleDbDataAdapte r1.Update(dt);
Console.WriteLi ne("Update successful.");
}
catch(Exception ex){
Console.WriteLi ne("Update unsuccessful.") ;
Console.WriteLi ne(ex.Message);
}
Minimalist code to be sure. All I did was replace one
string value with another and try to update. I get the
following error:

Concurrency violation: the UpdateCommand affected 0
records
Any ideas?

-----Original Message-----
I am having difficulty performing updates and deletions
on an Access database using the Update() method of the
OleDBDataAdapt er. I can insert rows without a problem,
but I get a concurrency exception when trying to update
or delete.

I am quite sure that no concurrency conflicts actually
exist. Is there a reason why the data adapter I am usingmay have a different row version that the database that
it got its data from?

I can work around the problem by removing the concurrencycheck from the update command, but would rather not
remove checking all together, for obvious reasons.

Has anybody experienced a similar problem with MS Access?

Thank you for any help.

P.S. The exact same code works flawlessly with SQL
Server, but I can't use it in this particular situation.
.

[Matt Burland]

What's your DataAdapter SelectCommand and UpdateCommand?

"Charlie Williams" <cw***********@ hotmail.spamfre e> wrote in message
news:0e******** *************** *****@phx.gbl.. .

Just to illistrate my point, I created a new project and
included this code:

DataTable dt = new DataTable();
oleDbDataAdapte r1.Fill(dt);
dt.Rows[5]["Superintendent "] = "Craig Birch";
try{
oleDbDataAdapte r1.Update(dt);
Console.WriteLi ne("Update successful.");
}
catch(Exception ex){
Console.WriteLi ne("Update unsuccessful.") ;
Console.WriteLi ne(ex.Message);
}
Minimalist code to be sure. All I did was replace one
string value with another and try to update. I get the
following error:

Concurrency violation: the UpdateCommand affected 0
records
Any ideas?

-----Original Message-----
I am having difficulty performing updates and deletions
on an Access database using the Update() method of the
OleDBDataAdapt er. I can insert rows without a problem,
but I get a concurrency exception when trying to update
or delete.

I am quite sure that no concurrency conflicts actually
exist. Is there a reason why the data adapter I am

using

may have a different row version that the database that
it got its data from?

I can work around the problem by removing the

concurrency

check from the update command, but would rather not
remove checking all together, for obvious reasons.

Has anybody experienced a similar problem with MS Access?

Thank you for any help.

P.S. The exact same code works flawlessly with SQL
Server, but I can't use it in this particular situation.
.

[Charlie Williams]

The update command was generated by VS.net I did not
alter it.

Select:
SELECT Added, Builder, Complete, CompleteDate, Details,
JobName, JobNumber, LeaveOffList, Notes, StartDate,
Super, TrenchDate, WorkType FROM Jobs WHERE (LeaveOffList
= false)

Update:
UPDATE Jobs SET Added = ?, Builder = ?, Complete = ?,
CompleteDate = ?, Details = ?, JobName = ?, JobNumber
= ?, LeaveOffList = ?, Notes = ?, StartDate = ?, Super
= ?, TrenchDate = ?, WorkType = ? WHERE (JobNumber = ?)
AND (Added = ? OR ? IS NULL AND Added IS NULL) AND
(Builder = ? OR ? IS NULL AND Builder IS NULL) AND
(Complete = ?) AND (CompleteDate = ? OR ? IS NULL AND
CompleteDate IS NULL) AND (Details = ? OR ? IS NULL AND
Details IS NULL) AND (JobName = ? OR ? IS NULL AND
JobName IS NULL) AND (LeaveOffList = ?) AND (Notes = ?
OR ? IS NULL AND Notes IS NULL) AND (StartDate = ? OR ?
IS NULL AND StartDate IS NULL) AND (Super = ? OR ? IS
NULL AND Super IS NULL) AND (TrenchDate = ? OR ? IS NULL
AND TrenchDate IS NULL) AND (WorkType = ?)

-----Original Message-----
What's your DataAdapter SelectCommand and UpdateCommand?

"Charlie Williams" <cw***********@ hotmail.spamfre e> wrote in messagenews:0e******* *************** ******@phx.gbl. ..

Just to illistrate my point, I created a new project and included this code:

DataTable dt = new DataTable();
oleDbDataAdapte r1.Fill(dt);
dt.Rows[5]["Superintendent "] = "Craig Birch";
try{
oleDbDataAdapte r1.Update(dt);
Console.WriteLi ne("Update successful.");
}
catch(Exception ex){
Console.WriteLi ne("Update unsuccessful.") ;
Console.WriteLi ne(ex.Message);
}
Minimalist code to be sure. All I did was replace one
string value with another and try to update. I get the
following error:

Concurrency violation: the UpdateCommand affected 0
records
Any ideas?

>-----Original Message-----
>I am having difficulty performing updates and deletions >on an Access database using the Update() method of the
>OleDBDataAdapt er. I can insert rows without a problem, >but I get a concurrency exception when trying to update >or delete.
>
>I am quite sure that no concurrency conflicts actually
>exist. Is there a reason why the data adapter I am

using

>may have a different row version that the database that >it got its data from?
>
>I can work around the problem by removing the

concurrency

>check from the update command, but would rather not
>remove checking all together, for obvious reasons.
>
>Has anybody experienced a similar problem with MS Access? >
>Thank you for any help.
>
>P.S. The exact same code works flawlessly with SQL
>Server, but I can't use it in this particular situation. >.
>

.

[Matt Burland]

One problem I had before was when I was missing a parameter the
UpdateCommand, for some strange reason when you are missing a parameter it
throws a very misleading concurrency exception rather than something more
informative. Now I'm not saying that's your problem but you might check the
parameter collection of your update command and see if they are all there.
Another thing you might try is hooking the RowUpdating event of your
DataAdapter and examining the actual values that are being passed. I use
something like this:

public void MyRowUpdateHand ler(object sender, OleDbRowUpdatin gEventArgs e)

{

System.Diagnost ics.Debug.Write Line(e.Command. CommandText);

string myparams = "";

foreach (OleDbParameter thisparam in e.Command.Param eters)

{

if (thisparam.Valu e!=null)

{

myparams += thisparam.Sourc eColumn + " " + thisparam.Value .ToString() +
"\n";

}

}

System.Diagnost ics.Debug.Write Line(myparams);

}

It sometimes helps to diagnose a problem. Give it a try and see if you spot
anything odd.

"Charlie Williams" <cw***********@ hotmail.spamfre e> wrote in message
news:03******** *************** *****@phx.gbl.. .

The update command was generated by VS.net I did not
alter it.

Select:
SELECT Added, Builder, Complete, CompleteDate, Details,
JobName, JobNumber, LeaveOffList, Notes, StartDate,
Super, TrenchDate, WorkType FROM Jobs WHERE (LeaveOffList
= false)

Update:
UPDATE Jobs SET Added = ?, Builder = ?, Complete = ?,
CompleteDate = ?, Details = ?, JobName = ?, JobNumber
= ?, LeaveOffList = ?, Notes = ?, StartDate = ?, Super
= ?, TrenchDate = ?, WorkType = ? WHERE (JobNumber = ?)
AND (Added = ? OR ? IS NULL AND Added IS NULL) AND
(Builder = ? OR ? IS NULL AND Builder IS NULL) AND
(Complete = ?) AND (CompleteDate = ? OR ? IS NULL AND
CompleteDate IS NULL) AND (Details = ? OR ? IS NULL AND
Details IS NULL) AND (JobName = ? OR ? IS NULL AND
JobName IS NULL) AND (LeaveOffList = ?) AND (Notes = ?
OR ? IS NULL AND Notes IS NULL) AND (StartDate = ? OR ?
IS NULL AND StartDate IS NULL) AND (Super = ? OR ? IS
NULL AND Super IS NULL) AND (TrenchDate = ? OR ? IS NULL
AND TrenchDate IS NULL) AND (WorkType = ?)

-----Original Message-----
What's your DataAdapter SelectCommand and UpdateCommand?

"Charlie Williams" <cw***********@ hotmail.spamfre e>

wrote in message

news:0e******* *************** ******@phx.gbl. ..

Just to illistrate my point, I created a new project and included this code:

DataTable dt = new DataTable();
oleDbDataAdapte r1.Fill(dt);
dt.Rows[5]["Superintendent "] = "Craig Birch";
try{
oleDbDataAdapte r1.Update(dt);
Console.WriteLi ne("Update successful.");
}
catch(Exception ex){
Console.WriteLi ne("Update unsuccessful.") ;
Console.WriteLi ne(ex.Message);
}
Minimalist code to be sure. All I did was replace one
string value with another and try to update. I get the
following error:

Concurrency violation: the UpdateCommand affected 0
records
Any ideas?
>-----Original Message-----
>I am having difficulty performing updates and deletions >on an Access database using the Update() method of the
>OleDBDataAdapt er. I can insert rows without a problem, >but I get a concurrency exception when trying to update >or delete.
>
>I am quite sure that no concurrency conflicts actually
>exist. Is there a reason why the data adapter I am
using
>may have a different row version that the database that >it got its data from?
>
>I can work around the problem by removing the
concurrency
>check from the update command, but would rather not
>remove checking all together, for obvious reasons.
>
>Has anybody experienced a similar problem with MS Access? >
>Thank you for any help.
>
>P.S. The exact same code works flawlessly with SQL
>Server, but I can't use it in this particular situation. >.
>

.