Guys,

When a use Access 97 to link to my Sybase database using ODBC I get
this error message when doing a select from.

Can't perform join, group, sort, or indexed restriction. A value being
searched or sorted on it to long

Can anyone explain this? I can't find any help on google or by
Microsoft support when searching for the error message.

The database table I am trying to query looks like this:

CREATE TABLE dbo.CreditCurves
(
CurveName char(255) NOT NULL,
stichtag datetime NOT NULL,
Currency char(3) NULL,
Location char(3) NULL,
BondISIN char(255) NULL,
DayCountBasis char(15) NULL,
CouponFrequency int NULL,
PayHolidays char(255) NULL,
SwapDayConvention char(255) NULL,
CreditTemplate char(255) NULL,
SwapDaysToSpot int NULL,
CreditEvent char(2) NULL,
Seniority char(3) NULL,
SeniorityMarkIT char(255) NULL,
GlobalCode char(25) NULL,
MarkITCode char(255) NULL,
CreditFamily char(255) NULL,
CreditFamilyMarkITLongName char(255) NULL,
IsPrimaryCurve bit NOT NULL,
CONSTRAINT CreditCurv_800033162
PRIMARY KEY NONCLUSTERED (CurveName,stichtag)
)


Regards,
Lars Schouw