Originally posted by nigelrivett
Can't you just call the SP from the client?
Openrowset will create a new connection and can cause unexpected problems.
No because requirement is that i have to write the query in access.
Currently there is a link table from Access to SQL Server. So if i create a view then there is no need for duplication and storing of data. Thats the reason i want to create the view with a SP.