Cannot join on Memo, OLE, or Hyperlink Object

I have a basic table in an Access database. In that table, I have a 10-digit numeric field that is stored as Long Text (leading zeros are significant). I extracted the unique values from that field in the table, and created a new table/field with the same Long Text data type. When I try to join that field back to the original table, I get the error: Cannot join on Memo, OLE, or Hyperlink Object. Is there a work around for this, or a known problem I need to address?

Related Posts:

  1. You cannot add or change a record because a related record is required in table ‘table_name’
  2. What is a CSRF token? What is its importance and how does it work?
  3. ssh connect Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password)
  4. UML Sequence diagram auto-numbering in Visual Paradigm
  5. How to get Twitch watchtime (like streamelements)
  6. What is the difference between functional and non-functional requirements?
  7. Mealy v/s. Moore
  8. Error 6 (net::ERR_FILE_NOT_FOUND): The files c or directory could not be found
  9. C compiler for Windows?
  10. what is gitpod: what does it actually do?
  11. What is JNDI? What is its basic use? When is it used?
  12. ngrok: tcp forwarding to 25565 (minecraft server)
  13. How does CheatEngine’s speed hack work?
  14. How do I use the yfinance API in Python to get today’s DJI open?
  15. Floating div positioning
  16. Eclipse CDT project built but “Launch Failed. Binary Not Found”
  17. Using $this when not in object context in PHP
  18. Difference between SIP and SIPS URI?
  19. ‘str’ object has no attribute ‘decode’. Python 3 error?
  20. Scroll to the top of the page using JavaScript?
  21. Generate pdf from HTML in div using Javascript
  22. new types may not be defined in a return type – C++
  23. What is the point of LRPC? Why would anyone want to make Remote Procedure Calls to the same machine?
  24. PHP password_hash(), password_verify()
  25. Uncaught TypeError: Cannot read property ‘style’ of null – JS error
  26. WinSCP: Permission denied. Error code: 3 Error message from server: Permission denied
  27. Can you use if/else conditions in CSS?
  28. How to record Android device’s screen on Android version below 4.4 (KitKat)
  29. Jenkins: 403 No valid crumb was included in the request
  30. class << self idiom in Ruby
  31. jQuery preventDefault() not triggered
  32. IE11 prevents ActiveX from running
  33. How to execute AngularJS controller function on page load?
  34. Does VBA contain a comment block syntax?
  35. ReactJS giving error Uncaught TypeError: Super expression must either be null or a function, not undefined
  36. What is O(1) space complexity?
  37. Windows Scheduled task succeeds but returns result 0x1
  38. Has the nativescript sidekick discontinue?
  39. decision tree in R error:fit is not a tree,just a root
  40. Different meanings of brackets in Python
  41. repaint() Method in Java
  42. Getting Access Denied when calling the PutObject operation with bucket-level permission
  43. What is the relationship between PyTorch and Torch?
  44. Downgrade npm to an older version
  45. Mongoose.js: remove collection or DB
  46. slideToggle JQuery right to left
  47. Valgrind Invalid free() / delete / delete[] / realloc() in C
  48. Exception in thread “main” java.lang.reflect.InvocationTargetException
  49. “webxml attribute is required” error in Maven
  50. How can I change the color of my prompt in zsh (different from normal text)?
  51. mkdir c++ function
  52. What’s the difference between SoftReference and WeakReference in Java?
  53. Identity matrix in Julia
  54. Letsencrypt renewal fails: Could not bind to IPv4 or IPv6.. Skipping
  55. Devise lockable – How to unlock account using unlock_in
  56. How to bind multiple values to a single WPF TextBlock?
  57. reversing list in Lisp
  58. How to disable Windows Update Medic Service?
  59. Systrace for Windows
  60. How do I count unique items in field in Access query?
  61. Good way to encapsulate Integer.parseInt()
  62. TCP/IP packets and datagrams
  63. ArrayList of int array in java
  64. What are the differences between Mustache.js and Handlebars.js?
  65. Vim Opening File E325 Attention Error
  66. Terminating app due to uncaught exception ‘NSUnknownKeyException’
  67. 2CHECKOUT ERROR CODE:PE102
  68. Android Debugging Failing With “Couldn’t connect to logcat, GetProcessId returned: 0” FFImageLoading.Platform.dll.so Not Found
  69. PHP – Indirect modification of overloaded property
  70. How to parse wordpress options json
  71. use wp_get_theme() to get theme author name
  72. Displaying a message when plug-in is deactivated
  73. get_previous_post in same categories
  74. Cannot understand WordPress error message
  75. Add column(s) to post edit page
  76. How can i hide and display elements automatically?
  77. How to change the paginated posts link class?
  78. How use custom image size + ACF + background image
  79. Pass AJAX variable to PHP functions WordPress plugin
  80. Add query args if website open in mobile
  81. A little stumped – first WordPress theme
  82. Display shortcode based on user meta
  83. Woocommerce Image Categorie Page
  84. Hide image on homepage [closed]
  85. How to Unban an IP properly with Fail2Ban
  86. How to see stdout of ansible commands?
  87. Difference between KVM and QEMU
  88. Top level domain/domain suffix for private network?
  89. Are SSD drives as reliable as mechanical drives (2013)?
  90. The Joel Test for system administrator jobs
  91. How do I rename a task in Task Scheduled on Windows Server 2008 R2
  92. How do I get the history of “apt-get install” on Ubuntu?
  93. Why does x86 represent 32bit when x64 represents 64bit? [closed]
  94. How to reload screenrc without restarting screen?
  95. How long before an s3 bucket can be created with same name after deletion?
  96. Software vs hardware RAID performance and cache usage
  97. How do high traffic sites service more than 65535 TCP connections?
  98. Using variables in Apache config files to reduce duplication?
  99. How to unify package installation tasks in ansible?
  100. Private IP address in public DNS

Leave a Comment