FIX: You cannot insert empty string into Memo, Text, nText, or Blob columns (316323)

MORE INFORMATION

Steps to Set Up the Database

1. Create a table "Test" in your Microsoft Access database.
2. Add the following two fields to the database:

   "Fld1" Data Type = "Text"
   "Fld2" Data Type = "Memo", Required="Yes", AllowZeroLength="Yes"

3. Make Fld1 the primary key.
4. Save the changes and close the database.

Steps to Reproduce the Problem

1. Start Visual Studio .NET.
2. Create a new Microsoft Windows application in Visual Basic .NET.
3. Make sure that your project contains a reference to the System.Data namespace.
4. Place a command button on Form1. Change the Name property of the button to "btnTest" and the Text property to "Test".
5. Use the Imports statement on the System and System.Data namespaces, so that you do not have to qualify declarations in those namespaces later in your code. Add the following to the General Declarations section of Form1, as follows:

   Imports System
   Imports System.Data.OleDb
   					

6. Paste the following code in the code window, after the region "Windows Form Designer generated code":

   Private Sub btnTest_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTest.Click
       Try
           Dim myConnString As String = _
                   "Provider = Microsoft.Jet.Oledb.4.0;Data Source=c:\nwind1.mdb;"
           Dim mySql As String = "SELECT * FROM Test"
           Dim ds As New DataSet()
           Dim conn As New OleDbConnection(myConnString)
           conn.Open()
   
           Dim da As New OleDbDataAdapter(mySql, conn)
           da.MissingSchemaAction = MissingSchemaAction.AddWithKey
           da.Fill(ds, "Test")
   
           Dim dr As DataRow
           dr = ds.Tables("Test").NewRow
           dr("Fld1") = "1111"
           dr("Fld2") = ""
           ds.Tables(0).Rows.Add(dr)
   
           Dim cb As New OleDbCommandBuilder(da)
           da.Update(ds, "Test")
   
           conn.Close()
       Catch ex As Exception
           MessageBox.Show(ex.ToString)
       End Try
   End Sub
   					

7. Modify the connection string (myConnString) as appropriate for your environment.
8. Save your project. On the Debug menu, click Start to run your project.
9. Click Test.
   
   Notice that an exception is generated when you attempt to update.