Thank you David,
But before I try that work around, why am I able to make the linked connection from server 1 to server 2 (access app) but not from my pc. I'm using EM to create the linked server. If it is a permission issue wouldn't it also apply to both scenarios?
Thanks again,