Extracting Long String Fied from SQL Server to Access 2003

[Helal]

I have designed a report that dynamically (via ODBC) pulls data from SQL
Server back end tables. One field in SQL table is a memo text and the length
is way over 255. I need to pull this filed as is into my Access 2003 report.
So far, the memo filed shows blank in my report. Any help will be greatly
appreciated.

Thanks,

 

[Jeff Boyce]

Are you using a query to return the data before putting it into the report?
Does the query work?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Helal]

Jeff,
Yes, I use a query and query doesn't work either...unless I remove the field
that contains long string.

Regards,

Helal

 

[Jeff Boyce]

Helal

I'll suggest that you post your question to either/both an Access query
newsgroup and a SQL-Server newsgroup. If the query doesn't return the
value, I doubt the report would be able to.

If the query can't "see" the long string, can you confirm that a linked
table can display it? By the way, do you have a linked table to that
SQL-Server table, or are you using a pass-through query, or are you using a
stored procedure?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Helal]

Jeff,
Thanks for your suggestions. Re-your questions, yes, I use a linked table
and I am using a pass thorugh query. I can extract the long string field
using SQL Analyzer or with any other SQL programs. It's just in Access that I
can't get that field. Did I answer your questiions?

Regards,
Helal

 

[Jeff Boyce]

Yes.

I'm at a loss for other ideas on what might be causing this.

Have you tried searching on-line for others who have seen something similar?

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/