Using Access to link Sybase tables and whenever I have multiple rows with same key, the other fields "stick" with the information from the first row of this key value. For example:

ADMIN, ABC123
ADMIN, DEF345
ADMIN, GHI678

appears as:

ADMIN, ABC123
ADMIN, ABC123
ADMIN, ABC123

where ADMIN is the unique key.

Using "refresh" corrects some, but not all, of the rows.

I believe that might be an issue with the table configuraion in sybase, since I have used similar linked Sybase tables in the past and have not encountered this issue. Any help would be appreciated.