Updating a MVF from a query

[Dave_D]

I'm trying to update a multi-valued field (attachments) using the following SQL but I'm getting the following error:
An UPDATE or DELETE query cannot contain a multi-valued field. 3826

If Me.LstAttachment.ListCount > 0 Then
For I = 0 to Me!LstAttachment.ListCount -1
Attch = Me.LstAttachment.ItemData(I)


sSql = "UPDATE tbl_IssueLst " _
& "Set ShareDoc = ' " & Attch & " ' " _
& "Where ID = " & Me!ID
next I
End If

What are my alternatives of getting this MVF updated?

[JoeM]

While I strongly suggest NOT using MVFs (they are not supported by other database programs like SQL and Oracle), see if this helps: https://support.office.com/en-us/art...624e1e323a#bm8

[Dave_D]

I absolutely agree with you of not using MVFs fields, but the end user insist upon it. I've seen this link before and what I'm trying now is this, just to see if I can get a record inserted into this MVF field:

INSERT into tbl_IssueList [ShareDoc.FileName]
Values ("Legal Name in Document.msg")
Where ID = 292

​

but I receive the following:

[June7]

AFAIK, Attachment field requires VBA manipulating recordset objects to programmatically insert/delete/replace file. Topic has been asked and answered many times http://www.fmsinc.com/microsoftacces...mentFields.htm

Saving files in db can quickly use up Access 2gb file size limit.