Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • Last Modified:

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

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"
0
mickeyshelley1
Asked:
mickeyshelley1
  • 3
1 Solution
 
peter57rCommented:
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?
0
 
mickeyshelley1Author Commented:
The problem in this case was a corrupt record, once i deleted it it solved the problem
0
 
mickeyshelley1Author Commented:
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
0
 
mickeyshelley1Author Commented:
I discovered the problem myself
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now