Can you clarify what you mean by a linked server? Is that being done at the SQL Server level so that the view shows up in the SQL database where your application tables are stored? Or are you doing something with ODBC links? I should also add that the ADP model is not supported in the current (2013) version of Access, so you may want to rethink your architecture if this is a new development.