View Permission question - Please help

[smsmail]

Hello,

I have an application, the front end is Access and the back end is sql server 2008 express.

The application does not display the view on a user's machine. Do I have to grant permission for the user, in order for the view to display?

I have tried granting permission, but I am doing something wrong. Please help!

Where do I start?

 

[dhulbert]

When access connects to the SQL server have you got and ODBC connection set up?

Does the ODBC use windows authentication or a fixed username?

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[smsmail]

Thank you Dhulbert for your help.

I do have a ODBC connection set up.

According to the VIEW connection properties in sql server the
Authentication Method is Windows Authentication, and Username is me. Is that why the view can not be seen by others?