Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View Permission question - Please help

Status
Not open for further replies.

smsmail

Programmer
Aug 11, 2010
105
US
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?
 

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)
 
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?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top