MS Access : cannot join on Memo,OLE,od Hyperlink object

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • shaguna.dhall@intrasphere.com

    MS Access : cannot join on Memo,OLE,od Hyperlink object

    I have a MS Access Db,which I migrated to Oracle.I created linking with
    oracle tables in my Access db.Both MS Access and Oracle db have unicode
    characters.
    I need to test whether the data is same in both databases.

    I'm using Access db and linked tables of Oracle.I perform join on the
    tables to get records. When I run the query on Access db to compare,I
    get the following error

    "cannot join on Memo,OLE,od Hyperlink object"

    How do i test the data between Access and linked tables in Oracle?

    Any suggestions would be helpful.

    Thanks

Working...