How to update the Microsoft data access table column value which is OLE Object type. RRS feed

  • Question

  • hi,

    Actually I have to modify the column value, which is XML string, in MDB datatable. Due to that column type is OLE Object,

    I couldn't see the actual data. Can anyone help me how to modify the data?


    Thursday, November 14, 2019 12:15 PM

All replies

  • XML strings should be stored in fields with Memo type, not OLE type.

    -Tom. Microsoft Access MVP

    Thursday, November 14, 2019 5:47 PM
  • That field exists already, I just want to modify the data.
    Monday, November 18, 2019 12:58 PM