Vb 2005 - Concurrency violation: the UpdateCommand affected 0

[wintermj]

Ok someone please for the love of god help me solve this problem. I have our SQL 2000 db running remotely on our 2nd DC. Not being the most amazing SQL user in the world (we have no dba) i set up quickly a database to record the weekly reviews on learners. I used varchar. I had a few concurrencey issues that i sorted by making sure all the update code was correct and i was then able to update via a datagridview with a simple Dataset.update command on the form close. I then decided to change the datatype from varchar (within sql) to nvarchar. So i went back through all my code and changed varchar to nvarchar and string. And i started to recieve conc violations namely: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records. I even ran through the schema to check all Datatypes were correct and they appear to be. I was using the tableadapter and update commands i specified within there to keep concurrency as this will be a multi user system and i wanted that checking to be in place. I have tried creating a new program, using a brand new connection and dataset with just a form and a datagridview. It propegates correctly but refuses to update even tho i know the command worked before i changed to nvarchar. Anyone have any ideas? I would appreciate any help anyone can give me on this. Normally concurrencey violations are a result of your update command incorrectly config's, in the wrong order or the datatypes are wrong. But i swear this should work. cheers Mike