Kayleigh Member Local time Today, 02:42 Joined Sep 24, 2020 Messages 709 Mar 24, 2022 #1 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?
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?
S sonic8 AWF VIP Local time Today, 03:42 Joined Oct 27, 2015 Messages 1,235 Mar 24, 2022 #2 Please describe the problem in more detail.
Kayleigh Member Local time Today, 02:42 Joined Sep 24, 2020 Messages 709 Mar 24, 2022 #3 I will attach some screenshots to demonstrate. Here is the view open in SSMS correctly: This is view in MS Access - some data displaying repeatedly:
I will attach some screenshots to demonstrate. Here is the view open in SSMS correctly: This is view in MS Access - some data displaying repeatedly:
S sonic8 AWF VIP Local time Today, 03:42 Joined Oct 27, 2015 Messages 1,235 Mar 24, 2022 #4 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.
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.
Kayleigh Member Local time Today, 02:42 Joined Sep 24, 2020 Messages 709 Mar 24, 2022 #5 Your a legend! Thanks
