Results 1 to 3 of 3
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Cannot join on Memo, OLE, or Hyperlink Object (A2k Sr1)

    I recently received an error message, Cannot join on Memo, OLE, or Hyperlink Object, while joining two tables. I am importing data from MS project via the transfer database do.command but have done this before without getting the error. I tried to compact and repair the database but still get the error. I am not using hyperlink or Memo fields. Any ideas??
    Regards,

    Gary
    (It's been a while!)

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot join on Memo, OLE, or Hyperlink Object (A2k Sr1)

    Francois

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Cannot join on Memo, OLE, or Hyperlink Object (A2k Sr1)

    Francois,

    Thanks,

    This was the problem I encountered. I have fixed this in the past by running a query that takes a subset of the original data and populates a new table. The join is then made against the new table. I will try this to see if it works. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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