[AccessD] Linked Table field Size

The link is actually to a view in SQL.  The view returns more than 100
characters if they are present.  There is code to re-link the tables/views
so that each user can log on as themselves.  Using the code, or link
external tables, the number of characters is the same.

This is a commercial product to create reports that I have modified.

Debbie

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, September 13, 2007 1:53 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Linked Table field Size

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

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