none
Access 2013 Error 3118 RRS feed

  • Question

  • I have two tables. Each contains a LONG TEXT field:

    tblContacts.tempContactType

    tlbImport.ContactType

    I need to join them in an Access query.

    I am getting Error 3118:

    Cannot join on Memo or OLE Object <name>. (Error 3118)

    I have checked over & over:  both fields above are defined as LONG TEXT.

    Any workaround for this error?

    Thanks!


    A. Wolf

    Wednesday, August 31, 2016 5:55 PM

Answers

  • As the message says, you just simply cannot use Long text fields in a Join. What do you want to achieve? Do you want to know which Long Text fileds in the two tables are equal? How are the two tables related? What are their key fields?

    Matthias Kläy, Kläy Computing AG

     
    • Marked as answer by amywolfie Wednesday, August 31, 2016 6:23 PM
    Wednesday, August 31, 2016 6:05 PM

All replies

  • As the message says, you just simply cannot use Long text fields in a Join. What do you want to achieve? Do you want to know which Long Text fileds in the two tables are equal? How are the two tables related? What are their key fields?

    Matthias Kläy, Kläy Computing AG

     
    • Marked as answer by amywolfie Wednesday, August 31, 2016 6:23 PM
    Wednesday, August 31, 2016 6:05 PM
  • The reason you cannot do this is performance: long text fields can have 2 billion characters, and joining them would be a very slow affair. Other database engines have the same restriction.

    You may be able to use a Where clause where you're comparing the Left(YourField, 255) in each table.


    -Tom. Microsoft Access MVP

    Wednesday, August 31, 2016 6:18 PM
  • Thanks.  Changed them to Short Text. Was trying to back into a key.


    A. Wolf

    Wednesday, August 31, 2016 6:23 PM