Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Thanked 0 Times in 0 Posts

    Runtime error 3702 (ACCESS 2000)

    I am making an ODBC link to Oracle 9i running PeopleSoft Learning Systems software. When I try to delete a row through an ODBC link (Oracle driver) I get a runtime error "Run-time error 3702 - The width of a unicode text column must be an even number of bytes." The PeopleSoft table does have a large text field which Access interprets as a memo. I really need this functionality and I don't know what to do about this error. Has anyone encountered this and found a solution? Thanks, Jim Allison

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: Runtime error 3702 (ACCESS 2000)

    Access/Jet assumes by that memo (and text and Hyperlink) fields are UniCode and does compression on the field for all characters where the first byte is 0. However for memo fields it only compresses if the field is 4096 characters or less - good question why, but . . . I suspect the Oracle driver doesn't deal with that quite right - have you tried using the Microsoft driver for Oracle?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts