I did some digging around and found a sample of C# code where they were passing SET NULL OFF. However, I can't seem to get it to work using VB.NET. I pass in the SET NULL OFF command and issue a ExecuteNonQuery() on that command. I then pass in my insert command and issue an ExecuteNonQuery() but I still get the error (field name XXX does not accept null values). Do you have any samples of this code using VB.NET?