error "concurency violation"

  • Thread starter Thread starter Toufik
  • Start date Start date
T

Toufik

Hi,
I've the folowing error "Concurency violation, The update command affected 0
records", when I execute the save command "DA.Update(DS, "tblName")"
DA is a dataadapter linked to a commandBuilder.

How can I debug the error, know what is the error... what is the exact
update command



thanks
 
Verify your database field names, lengths and types are the same as in your
dataset. You can view the dataset in code view to check these things.

Also check your primary key updating code. If you failed to increment this
could also cause errors but it is hard ot know without seeing code.
 
Toufik,

Is this Access with Autoincrementkey?

Or give otherwise some more details.

Cor
 
Thanks friends,
it's an ms-access2000 DB, but without autoincrement.

The error is occuring when I change a value (not a new row), I'm in MONOPOST
environment.

Any Hint?
 
Yeah lets see your update code. Also complete error message. (ex.message).

Their is a problem with the value you are inserting into the row.

Do you have a primary key in the table?

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com
 
Back
Top