This one has me totally baffled.
  When I call information from a memo field in an Access 2000 stored 
procedure based on 2 databases, only the first 256 characters are 
displayed. After hours of trying different strategies I then tried the 
similar routine calling the information from a database instead of the 
stored procedure. Eureka! All of the information from the memo field is 
displayed.
  The issue is that I need the information from both databases used in the 
stored procedure. I can conceivably restructure the databases and rewrite 
my ASP code but I'd rather not do that unless I have to.
  Any ideas?

Whilst this doesn't directly address your problem:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q200124
it does highlight the fact that you need to treat Memo fields differently to
other types of fields, due to the nature of a memo field. You should be
using a chunking system to get the data into the recordset object.

BTW, is all the data returned properly if you run the parametised query
within Access? (I'm just curious)

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Joseph Fridman" <yfridmn@n...>
Subject: [access_asp] Truncated Stored Procedure


:   This one has me totally baffled.
:   When I call information from a memo field in an Access 2000 stored
: procedure based on 2 databases, only the first 256 characters are
: displayed. After hours of trying different strategies I then tried the
: similar routine calling the information from a database instead of the
: stored procedure. Eureka! All of the information from the memo field is
: displayed.
:   The issue is that I need the information from both databases used in the
: stored procedure. I can conceivably restructure the databases and rewrite
: my ASP code but I'd rather not do that unless I have to.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ken-
Regarding chunks. I've worked with memo fields within several sites and 
have never found it necessary to use chunks.

Regarding the running of the data within Access- I have the same problem. 
The data within the procedure is limited to 256 characters and all of the 
data within the data field is accessible when it is accessed directly from 
the table.

Can anyone help me with my original issue.

Joseph


> Whilst this doesn't directly address your problem:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q200124
it does highlight the fact that you need to treat Memo fields differently 
to
other types of fields, due to the nature of a memo field. You should be
using a chunking system to get the data into the recordset object.

BTW, is all the data returned properly if you run the parametised query
within Access? (I'm just curious)

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Joseph Fridman" <yfridmn@n...>
Subject: [access_asp] Truncated Stored Procedure


:   This one has me totally baffled.
:   When I call information from a memo field in an Access 2000 stored
: procedure based on 2 databases, only the first 256 characters are
: displayed. After hours of trying different strategies I then tried the
: similar routine calling the information from a database instead of the
: stored procedure. Eureka! All of the information from the memo field is
: displayed.
:   The issue is that I need the information from both databases used in 
the
: stored procedure. I can conceivably restructure the databases and rewrite
: my ASP code but I'd rather not do that unless I have to.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Joseph Fridman" <yfridmn@n...>
Subject: [access_asp] Re: Truncated Stored Procedure


: Regarding chunks. I've worked with memo fields within several sites and
: have never found it necessary to use chunks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I've lived in several houses and never been burgled. Doesn't mean that I
don't have insurance... :-)

When Microsoft says "use .GetChunk" then I tend to listen, regardless of my
personal experience.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q200124

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: Regarding the running of the data within Access- I have the same problem.
: The data within the procedure is limited to 256 characters and all of the
: data within the data field is accessible when it is accessed directly from
: the table.
:
: Can anyone help me with my original issue.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I'm trying. Can you post the procedure you are using?

Cheers
Ken