Hi,<BR><BR>I&#039;m trying to use a DataAdapter to handle some changes between a DataTable and an Access database.<BR><BR>The problem I&#039;m running into is strange, and it does not seem to matter whether or not I use an OleDbCommandBuilder.<BR><BR>When I call Adapter.Update() I always get a message saying that such-and-such a field cannot be null b/c its required property is set to True. <BR><BR>This makes sense, and I have no problem with it. It makes sense b/c I&#039;m not always including every single field in my SQL Update command.<BR><BR>However, I should be able to get around this, by going into Access and setting all required fields with some default value, correct?<BR><BR>But this does not seems to work, and I can&#039;t figure out why.<BR><BR>Again, it doesn&#039;t matter if I use a CommandBuilder to auto-generate the SQL, or if I create it myself. The results are always the same.<BR><BR>Any ideas?<BR>-Steve<BR><BR><BR><BR>