By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,254 Members | 2,477 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,254 IT Pros & Developers. It's quick & easy.

Memo datatype got trucated

P: n/a
I am using MS Access 2000(runs on OS 2K) to do query on Oracle9i database.
If i use a simple query i will get all data that I query. However, if I do
multiple join tables (say join 8 tables from different databases) columns that
are of memo datatype are truncated ( the last portion of the data is
missing). Some people say not enough memory but my system is PIII and 256Mag

Since the query uses link tables from Oracle I am unable to attached to this
email. Can you help.

best rgs
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
If you use SELECT DISTINCT Access will truncate the Memo field, or
even refuse to run the query (depending on the version of Access)

I'm not at work now and can't remember exactly how I solved this. But
try: remove the Memo field from the SELECT DISTINCT query A, then make
a new SELECT DISTINCT query point to that query A

Nov 12 '05 #2

P: n/a
You are correct its the SELECT DISTINCT that is causing the field to
truncate. Tks...
But not sure how to do "a new SELECT DISTINCT query point to that query
A "


*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.