Solved View not displaying all data correctly (1 Viewer)

Kayleigh

Member
Local time
Today, 06:22
Joined
Sep 24, 2020
Messages
706
I have a view which is showing all data perfectly in SSMS but not in MS Access. I have tried refreshing link and deleting and re-linking but no success. Anything else I can try?
 

Kayleigh

Member
Local time
Today, 06:22
Joined
Sep 24, 2020
Messages
706
I will attach some screenshots to demonstrate.

Here is the view open in SSMS correctly:
ssms query.png


This is view in MS Access - some data displaying repeatedly:
query ms access.png
 

sonic8

AWF VIP
Local time
Today, 07:22
Joined
Oct 27, 2015
Messages
998
When Access prompted you to select one or more column(s) uniquely identifying the records in the view, you choose a column with non-unique values.
 

Users who are viewing this thread

Top Bottom