Sql Server View and Access Linked table to that view are different

[RayMilhon]

I have a View in SQL Server 2008 R2 that pulls the last 12 Months of Hospital Inpatients. I've linked to that view in MS Access 2010.

However if I look at the view in SQL Server and Patient A has multiple inpatient Visits. In the linked table in Access it shows the same record that many times.

Example

Patient John Smith was in the hospital Nov 1 through Nov 10 and again feb 15 through feb 20



SQL Server shows

Patient Admit Dt Disch Dt LOS
John Smith 11/01/2013 11/10/2013 10
John Smith 02/15/2014 02/10/2014 5


Access Shows
Patient Admit Dt Disch Dt LOS
John Smith 11/01/2013 11/10/2013 10
John Smith 11/01/2013 11/10/2013 10

this is in the linked table not in a query or anything else. Never seen anything like it. Anybody have a clue?????

[RayMilhon]

Don't know what caused it but I resolved the issue in SQL Server that required me to try and join these 2 views in Access. Now I can perform the join in SQL Server and everything works the way it's supposed to. Still no clue as to why the data was different between the view of the data in access and the View in SQL Server.