[AccessD] Linked Table field Size

I have refreshed the link and re-created it altogether.  Every interation
has the 100 character field length.

Debbie

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Thursday, September 13, 2007 1:47 PM
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