[AccessD] Linked Table field Size

Can you access the tables directly rather than through the view?  I
would be curious if it's related to the view verses physical table.

GK

On 9/13/07, Debbie Elam <delam at zyterra.com> wrote:
> Access 2000 and SQL 2000 also.  I do not think it is the program
> manufacturer, since I tried linking the view independent of the code that
> used for re-linking.  That was using standard Access tools.
>
> 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 3:49 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Linked Table field Size
>
> It isn't a limitation in Access but it may be some kind of limitation in
> the product you're using.  I've never run into that.  What version of
> SQL Server and Access are you using?
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie Elam
> Sent: Thursday, September 13, 2007 12:23 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [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
>
>
> --
> 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
>


-- 
Gary Kjos
garykjos at gmail.com