Access truncates SQL varchar(max)

#1

Hello. I have a SQLServer table with a varchar(max) column which I link to in Access. In design view, Access shows the column as having a Text data type with a field size of 255. Access displays the last 255 characters, and truncates data that's inserted into the field.

How can I get Access to see it as a memo field?

#2

Darrell Burns wrote:

Quote:

Hello. I have a SQLServer table with a varchar(max) column which I link to
in Access. In design view, Access shows the column as having a Text data
type with a field size of 255. Access displays the last 255 characters,
and truncates data that's inserted into the field.

How can I get Access to see it as a memo field?

That is not normal behavior. Every time I have linked to a table with a
VarChar larger than 255 Access has treated it as a memo.

The "usual" problem is having a VarChar larger than 255, but less than Max
which then Access wants to allow unlimited text and the server throws errors
when you input too many characters.

Are you using the latest driver? Have you tried deleting and re-creating
the link? Which version of Access and SQL Server?

Note that there are several scenarios where Access truncates even native
Access memo fields to 255, but that is in forms, reports, or queries.
Having this happen in a table link is not something I have heard of before.

#3

stop using Jet and start using 'Access Data Projects'

On Jul 30, 6:55*pm, Darrell Burns <u... (AT) compgroups (DOT) net/> wrote:

Quote:

Hello. I have a SQLServer table with a varchar(max) column which I link to in Access. In design view, Access shows the column as having a Text data type with a field size of 255. Access displays the last 255 characters, andtruncates data that's inserted into the field.

How can I get Access to see it as a memo field?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Access truncates SQL varchar(max)

comp.databases.ms-access comp.databases.ms-access

Access truncates SQL varchar(max) - 07-30-2010 , 08:55 PM

Re: Access truncates SQL varchar(max) - 07-31-2010 , 04:20 AM

Re: Access truncates SQL varchar(max) - 08-17-2010 , 02:23 AM