Query return all rows as the first row

[wvjim]

I'm using Access as a front end to SQL. When I attach the database and try to retrieve the records/rows it shows me multiple records but they all have the infromation from the first record. I'm stumped as to how to resolve this situation. I can go to a different computer and perform the same function and it works fine. Any sugesstions on how to resolve this situation would be greatly appreciated.

Thanks in advance.

 

[JonFer]

I have seen that error when I link a table but don't specify a unique record identifier or use an incorrect one. Is that applicable in your case?