This is configurable via the OleDb command line for your connection string.

Something like this works:

this.oConn = new OleDbConnection("Provider=vfpoledb.1;" + 
             @"Data Source=D:\Programs\vfp70\Samples\Data\testdata.dbc;" + 
              "Exclusive=false;Nulls=false");

You can find out more by looking at the VFP Interop document at:

http://www.west-wind.com/articles.asp

It's the oldest one of the bunch...






>When I execute a nonquery command (insert) from .NET to add a record to VFP db, .NET fails unless I specify _all_ fields. Otherwise, I get error "Field MYFIELD does not accept null values".
>This is, of course, different from inserting a record in VFP. Is there an option or some way to do it such that I only list some fields in the INSERT command?
>
>TIA.