SELECT returns more than one row (1 Viewer)

[83dons]

Hi

I am using a simple Pass Through Query in MS Access to pull data from a Sybase database and populate a table in Access. This query has always worked in the past but has recently been throwing back the following error message:

ODBC -- call failed.
[Sybase][ODBC Driver][Adaptive Server Anywhere]SELECT returns more than one row(#-185)

I have not changed the query so I am guessing this must be down to a data limit for the query being reached, a time out in connection or perhaps a duplicate row in the database or maybe a wrongly populated row?
I have tried the google search and found nothing to help - the table in Access did have a lot of rows at about 380,000 but it should manage more than this I reckon as the limit for an Access table is 2GB. Cananyone help please? Spent 2 days on this already! Maybe an alternative SQL query is needed. The current query is somehing like:

SELECT column1, column2, ...etc
FROM tablename;

SO basically selects all rows in a table in Sybase and certain columns and then puts them in an Access table.