<div>
I assume you are using a non-Access backend for your data? (If it's Access then you have a corrupt file) - so what are you connecting to and how are you connecting?
</div>


I assume you are using a non-Access backend for your data? (If it's Access then you have a corrupt file) - so what are you connecting to and how are you connecting?

<div>
I was appending from one table to another in the same Access file, the the problem was the memo field in the bad record had ############# displayed in it
</div>


I was appending from one table to another in the same Access file, the the problem was the memo field in the bad record had ############# displayed in it

<div>
I discovered the problem myself
</div>


<div>
<div class="content wysiwyg-content">
I am attempting to run an append query and i keep getting this error &quot;The width of the unicode text column must be an even number of bytes&quot;
</div>
</div>


I am attempting to run an append query and i keep getting this error "The width of the unicode text column must be an even number of bytes"

Error When Running Append Query &quot;The width of the unicode text column must be an even number of bytes&quot;

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Error When Running Append Query &quot;The width of the unicode text column must be an even number of bytes&quot;

Error When Running Append Query "The width of the unicode text column must be an even number of bytes"