OpenQuery does not accept variables for its arguments. To use dynamic parameters, you must construct the entire query string dynamically and execute it via EXEC(). Tip Use OpenQuery when interacting ...
I've got an ASP.NET app w/ a SQL backend. The SQL backend has a linked server (Access db) that is has several views that call from the linked tables. Everything works fine in QA and Enterprise manager ...