How to update an Access 2007 multi value memo field in SQL - C# windows app RRS feed

  • Question

  • I have a C# windows app that updates an Access 2007 database table using SQL. One of the fields is a memo field with append only set to yes. When the SQL update runs it fails with the error Object invalid or no longer set.


    If I change append only to no then the SQL runs OK and the field gets updated. This is one of the new Field2 multi values field types

    I am using Provider=Microsoft.ACE.OLEDB.12.0

    Does anybody know how to update an Access 2007 multi values memo field when append only is set to yes within a C# app using SQL or otherwise.


    Saturday, February 16, 2008 12:58 PM