What about this err.msg ??

[Mischamel]

An unhandled exception of type System.NullReferenceException occurred in commandbuilder (projectname).exe. Additional information: Value null was found where an instance of an object was required.

Code :

im INSERTCommand As New OleDbCommand(SQLStr, OleDbConnection1)

In another Sub I declared a Command, too and it works. What

 

[mutant]

It has nothing to do with your table values.
How did you declare your connection?

 

[viast]

What does your SQLStr look like. Check all the columns of the table. all the columns which do not have Allow Null against them should have some value in SQLStr.

 

[Mischamel]

Its a standard connection, declared by VB.Net

Here

 

[Nerseus]

Can we see ALL of the code in question?

-Nerseus