SELECT returns more than one row

[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.

[jbarrum]

To trobleshoot I would try filtering the query to see if your problem is in deed a size issue or it it is actually an ODB connection issue. Has anyting changed with either the DB server or the client computer that woud disrupt that ODBC connection?

Filter the report with a WHERE clause to see if you get any results.