Access shows duplicates in linked SQL View

[Guest]

I have a linked table in Access that is a view in a SQL 2005 database. The
view is a list of company names and phone numbers. There are usually more
than one phone number listed per company. It shows correctly in SQL
Management Studio. Each record for the company shows a distinct phone number.
Upon linking to the view in Access 2003 however, I see the same phone number
for each record of the company. Link Table Manager does not refresh the data
and a test of the underlying query in Access produces the correct result.

Does anyone have any idea why this is happening?

 

[Guest]

Try refreshing your tables through the Access linked table manager.

 

[Rick Brandt]

I have a linked table in Access that is a view in a SQL 2005
database. The view is a list of company names and phone numbers.
There are usually more than one phone number listed per company. It
shows correctly in SQL Management Studio. Each record for the company
shows a distinct phone number. Upon linking to the view in Access
2003 however, I see the same phone number for each record of the
company. Link Table Manager does not refresh the data and a test of
the underlying query in Access produces the correct result.

Does anyone have any idea why this is happening?

When you created the link you were prompted to select fields for creating a
local index. If you select fields that do NOT actually contain unique data you
can have what you are seeing. Delete and re-create the link. If you don't need
to do updates then just hit Cancel when prompted for the unique fields.