Thanks for your reply - Ive benn strruggling with this for days. I was just about to try what you suggested although I was trying to persist with the commandbuilder object which handles inserts, updates and deletes in the one dataset without knowing which row is which.

However, it occured to me that in my test database I have fields called 'Name' and 'Date' - obviously reserved word in an INSERT but not in an UPDATE ???

Changed the names to NAmeTest and DateTest and now works fine - I feel like a real Dork !!!