[AccessD] Data from a SQL Server Table

Manipulating the table should be done from the user interface.  It
sounds like you're talking about querying data out of the table and
having the field truncated, which is a different issue entirely.  If you
include the memo field in a groupby clause, it will truncate the data.
Check the archives for a couple of threads on query truncates memo
field.  Also keep in mind that the SQL Server text datatype will hold
more than the Access memo type.


Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Wednesday, May 03, 2006 6:38 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data from a SQL Server Table

I may have to do something like that because an export from access to a
text file only got the first 474 characters of the memo field. Why that
number I don't know. Certainly not a multiple of 2. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Long, Karen
S. (CDC/NIOSH/NPPTL) (CTR)
Sent: Wednesday, May 03, 2006 8:24 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data from a SQL Server Table

Too bad you can't use the Rich Text Format box from .net.  Have you
thought about using vb script to write the contents of the memo field to
a .txt file, displaying that document, making changes, and then send it
back to SQL?  I have some code that will do that - I had a problem sort
of like yours. 


Karen S. Long
Programmer Analyst
EG&G Technical Services, Inc.
Pittsburgh, PA
Phone: 412-386-6649
Email: cyx5 at cdc.gov


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Wednesday, May 03, 2006 8:43 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data from a SQL Server Table

The problem is I need to manipulate the data.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
Foust
Sent: Tuesday, May 02, 2006 5:17 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data from a SQL Server Table

Then if you can see the whole value in a form, what's the problem?  You
don't let users see the linked table anyhow. 


Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, May 02, 2006 2:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data from a SQL Server Table

If I directly open the table I do not see the whole memo field. If I
open it in a form I see the whole field.