[AccessD] Linked Table field Size

Charlotte Foust cfoust at infostatsystems.com
Thu Sep 13 17:25:09 CDT 2007


Good heavens!  Who remembers the uglies that lurked in Access 2000?  It
was more fun than 97 but it had more than its fair share of odd
crotchets.  Are all the service packs applied?  Maybe someone else who's
still using A2k can offer suggestions.

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 2:54 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Linked Table field Size

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




More information about the AccessD mailing list