I am using Office365/Access 2016 as a front-end, with an on-premises SharePoint 2013 list as a back-end.
The users need to leave notes for each other in the list, which should also retain a history of those notes.
I am using one multiline/Long Text field, called "latest_note", to enter the new note, which is then appended via an update query to another field, "notes", which is then the historical record of notes.
The process, effectively, adds the whole content of "notes" to the "latest_note", erases the "notes" field, and then UPDATEs it with the "latest_note" + "notes".
This works very nicely until the "latest_note" + "notes" hits around 2000 (2K/maybe 2048?) characters. At that moment, it raises the following error:
Run-time error '3000':
Reserved error (-1517); there is no message for this error.
Of course, then you have to force-close the app etc.
I did some limited testing and think that this is caused by Access not being able to add a text of 2K size to the field it's updating.
I do have some alternative workarounds for this issue, but am just curious to hear if anyone else has run into this specific error or limitation? I wasn't able to find a single reference googling it.