Since you are using Integrated Security, as long as you have permissions set both on the linked view in your local database, and on the view in the remote database, I would expect you should be able to open the view in the Access Data Project. As a test you could try linking the view into an empty .mdb database using ODBC, and see if you can open it that way. If not then I would expect to to be an issue with permissions at the SQL level. You could also try opening an ADO connection to that view in the remote database and see if that works.