[AccessD] Linked Table field Size

If you can access and change the table in the SQL Db change 
the field to a nvarchar(255) ...
failing this you have to work with the existing field 
length...
borge

---- Original message ----
>Date: Thu, 13 Sep 2007 11:37:40 -0500
>From: "Debbie Elam" <delam at zyterra.com>  
>Subject: [AccessD] Linked Table field Size  
>To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
>
>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