Cannot join on memo, OLE or Hyperlink Object

S

Steve Marsh

Join query against two linked SQL tables returning the
error "Cannot join on memo, OLE or Hyperlink Objects".
None of the columns in either table are memo or hyperlink.

Any comments regarding what might be the source of the
problem would be greatly appreciated.

Steve Marsh
 
M

Michel Walsh

Hi,

That just that, a memo or a large binary object cannot be used in a
join, or as a group, or as distinct, it is by design.


Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cannot have memo,ole or hyperlink object in aggregate argument 2
cannot join on Memo, OLE or hyperlink 7
Union Query with OLE and Memo fields? 4
MS Access : cannot join on Memo,OLE,od Hyperlink object 1
Join a concatenated field 5
cannot join on memo field 4
Can't Include Memo or OLE Object 10
Query to populate other fields 4

Top