Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Cannot join on Memo, OLE, or Hyperlink Object

  1. #1
    Board Regular SlinkRN's Avatar
    Join Date
    Oct 2002
    Location
    Illinois
    Posts
    683
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Cannot join on Memo, OLE, or Hyperlink Object

    Hi all, I am SO much more of an Excel person than an Access person so I hope someone can help me. I am trying to design a query based on two tables. One table is mom's info and the other is the newborn's info. I am trying to join MRN (medical record number) from the mom info table with MomMRN (mother's medical record number) from the newborn info table but I keep getting that "cannot join" error that's in the title of this post. I've searched and I've googled and I just cannot figure this out. Can anyone push me in the right direction? Thanks, Slink

  2. #2
    MrExcel MVP boblarson's Avatar
    Join Date
    Nov 2008
    Location
    Portland, Oregon, USA
    Posts
    1,964
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot join on Memo, OLE, or Hyperlink Object

    What data type are each of the fields? Check the field properties in the table and make sure that they are the same and are not one of the types listed in your error.
    Bob Larson
    Former Access MVP (2008-2010, 2011)

  3. #3
    Board Regular SlinkRN's Avatar
    Join Date
    Oct 2002
    Location
    Illinois
    Posts
    683
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot join on Memo, OLE, or Hyperlink Object

    Thanks Bob! That is the problem!! It is text in one table and Memo in the other. The problem is that it pulls from a sql database that I am not in control of. If I change the format of a field in one of the tables will I be messing up the sql database? Thanks, Slink

  4. #4
    MrExcel MVP boblarson's Avatar
    Join Date
    Nov 2008
    Location
    Portland, Oregon, USA
    Posts
    1,964
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot join on Memo, OLE, or Hyperlink Object

    What is the format of the one coming from the SQL database? I am assuming that it is the memo field and probably due to it being set to something liike varChar(Max).
    Bob Larson
    Former Access MVP (2008-2010, 2011)

  5. #5
    Board Regular SlinkRN's Avatar
    Join Date
    Oct 2002
    Location
    Illinois
    Posts
    683
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot join on Memo, OLE, or Hyperlink Object

    Both tables come from the sql database. I am using an ODBC connection to do queries on the database from Access. I really doubt that anything I do in Access would affect the database but I'm chicken unless I know for sure (I am already pretty sure since I have been told that the sql database updates the tables routinely so that any changes that are made would routinely be overturned.)

  6. #6
    MrExcel MVP boblarson's Avatar
    Join Date
    Nov 2008
    Location
    Portland, Oregon, USA
    Posts
    1,964
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot join on Memo, OLE, or Hyperlink Object

    Perhaps you could get the SQL DBA to create a view for you which you could then link to instead???
    Bob Larson
    Former Access MVP (2008-2010, 2011)

  7. #7
    Board Regular SlinkRN's Avatar
    Join Date
    Oct 2002
    Location
    Illinois
    Posts
    683
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot join on Memo, OLE, or Hyperlink Object

    Thanks for your help, I'll ask him about it, at least now I know what to ask about!

  8. #8
    New Member
    Join Date
    Mar 2009
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cannot join on Memo, OLE, or Hyperlink Object

    Hi, in what way should the view be created so that the Cannot join on memo error doesn't occur? I created a basic view and then an Access query which uses it but the error still comes up.

  9. #9
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    47,381
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Cannot join on Memo, OLE, or Hyperlink Object

    Hi, in what way should the view be created so that the Cannot join on memo error doesn't occur? I created a basic view and then an Access query which uses it but the error still comes up.
    You are probably better off starting your own thread/question than resurrecting an old one. Bob Larson has not been active on this board for a few years, so I doubt he will see/respond to your question, and most other people probably won't see the question, as it doesn't show up as a new unanswered question.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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