[AccessD] Linked Table field Size

Charlotte Foust cfoust at infostatsystems.com
Thu Sep 13 13:52:33 CDT 2007


I'm not sure I understand.  A linked table should reflect the field size
of the SQL Server table, not an arbitrary Access limit.  Can you explain
in a bit more detail what's going on, what kind of a linked table you
have, etc.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Thursday, September 13, 2007 11:47 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Linked Table field Size

Refresh the Link?

GK

On 9/13/07, Debbie Elam <delam at zyterra.com> wrote:
> I have a table in Access linked from MS SQL.  Access has determined 
> that the field length of a text field is 100 characters.  This works 
> 98% of the time, but a few fields have values that exceed 100 
> characters.  Does anyone know how to get Access to give me a longer
field length?
>
> Debbie
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list