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

S

Shaguna

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.
 

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

Retrieving data from Access 97 0
ODBC - Connecting MS Access to Oracle 10g 0
Linking Access and Oracle problem 4
Strange Asian looking characters in output 3
cannot have memo,ole or hyperlink object in aggregate argument 2
Error 3298:More than one table exists with same name 2
Change ODBC Data Source Name on the Fly Programatically 0
Migrating from 2010 to 2013 - having issues: Exporting to xml 0

Top