471,082 Members | 1,174 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,082 software developers and data experts.

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

Sep 22 '06 #1
0 3911

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Jan Szymczuk | last post: by
4 posts views Thread by alexandre.brisebois | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.