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?