Quote Originally Posted by jmcilhinney
If you don't have a primary key then how can you distinguish one record from another? There are times when it is appropriate to have a table without a primary key but they are very, very much in the minority. If this is one of those times then you can't use a CommandBuilder, plain and simple. The fact that you are trying to use a CommandBuilder at all suggests to me that this isn't one of those times though. How can you update or delete a record if you cannot uniquely identify it?
Hmmm. I created a primary key even though I didn't need it and now it works fine

jmcilhinney, I appreciate your patience....

[edit]: It says that I need to spread some reputations but I will remember this and I will come back and rate your post. It's a promise. I owe you two reps now