note
simon.proctor
If you are dealing with Memo fields from Access then you may find it best to create ADO objects directly. Here are nodes I wrote on these sometime in the distant past. They should provide a start point if you need it:
<ul>
<li>[id://98956]</li>
<li>[id://136679]</li>
</ul>
The above will show you how to connect, query and, if required, grab the insertion id of a new record if your logic requires it.
<br><br>
HTH
444859
444859