title: Critical Error #-2147217887 Multiple-step OLE DB operation generated errors
body: <p>I've converted an access DB to an SQL express DB using the built in upsizing wizard in MS access. But I now get an error when I try to programmatically add a record to the SQL server table:</p>
  
  <p>Critical Error #-2147217887  Multiple-step OLE DB operation generated errors.</p>
  
  <p>The field that this fails on is when I'm setting the SQL Field [notes]. I'm trying to set it to a vbnullstring (using VB6).</p>
  
  <p>The access upsizing wizard created the field as a nvarchar(255) and all nulls to true, it originally  was a text field with a length of 255 in ms access.</p>
  
  <p>Is there a problem setting a nvarchar field in sql to a vbnullstring?</p>
  
  <p>Any suggestions on what could be going wrong would be greatly appreciated!</p>
  
  <pre><code>Set RS = OpenRecordsetSQL("SELECT TOP 1 * FROM AvailabilityBlocks WHERE BlockID=-1") 
  ' ' Add a specific entry to the Availability DB Table ' 
  RS.AddNew 
  RS("Begin") = wblock.BeginTime 
  RS("Type") = wblock.BlockType 
  RS("OCampus") = wblock.Campus
  RS("End") = wblock.EndTime 
  RS("LocationID") = wblock.LocationID 
  RS("ResourceID") = wblock.ResourceID 
  RS("RecurringSetNumber") = wblock.RWWSetNumber 
  RS("Notes") = wblock.Notes 
  RS("InternalNotes") = wblock.InternalNotes 
  RS.Update 
  </code></pre>