[AccessD] Problem linking to an ODBC table

Thanks John,

I contacted software support and the solution was to use a pass-through
query.

Thanks,
Joe Rojas
IT Manager
TNCO, Inc.
781-447-6661 x7506
jrojas at tnco-inc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Tuesday, November 28, 2006 9:14 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Problem linking to an ODBC table

If I had to guess, I would say that one field in the table you are
linking
to is able to contain more data than Access can handle.  Perhaps Access
is
mapping a field as text when it actually contains more data than a text
field can handle (255 characters).  Or perhaps there is a field that
Access
simply does not understand how to map, contains a data type that Access
simply cannot handle.  I would look at the table itself, inside of
OpenEdge
and see what kinds of data the table contains. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Rojas
Sent: Tuesday, November 28, 2006 8:48 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Problem linking to an ODBC table

Hello,

I am using Access 2003 to connect to a Progress OpenEdge 10 database via
ODBC.
Everything is setup correctly but I am having a problem connecting to
one
particular table.

Each time I try to connect to it, I get an error message that says "The
size
of a field is too long."

Any ideas for a possible work around?

Thanks,
Joe Rojas
IT Manager
TNCO, Inc.
781-447-6661 x7506
jrojas at tnco-inc.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