Access 2013 Error 3118

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

Answer 1

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

 

Answer 2

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

Answer 3

Thanks.  Changed them to Short Text. Was trying to back into a key.

---

A. Wolf