Access Linked Tables Rights issue

[Stephan Fix]

I have a bit of a brain teaser. I have a user that created an Access doc
that links to tables in a SQL database. Some users can use the doc and
others fail with an authentication issue. For example, one user that is able
to open the doc and run queries has only read permissions to the file and no
access to the SQL database, but is given the option to put in a different
user to get into SQL when she runs a query. I can't run the doc, yet I have
read/write access to the doc and an account on the SQL server. There is no
ODBC connection set. When I log into my machine as the "other" user I am
able to run the queries. The permissions in Access are the defaults. Any
ideas?

 

[Mary Chipman [MSFT]]

You're going to need to get hold of your SQL Server admin to grant
permissions to the various users who need to use the data. Access
permissions don't count when it comes to SQL Server data.

--Mary

 

[Stephan Fix]

That's where this problem has been getting me. The user that can connect
successfully (although when prompted for db access she has to enter a
different user) does not have a user account on the db. I have
administrative access to the db, yet I don't connect.

 

[Mary Chipman [MSFT]]

I'm sorry, but you have not provided enough information for anyone to
be able to assist you with your problem. Please see your system
administrator who can troubleshoot your problem on site. If you don't
have a system administrator for your SQL Server, then perhaps this
link can help you understand what's going on:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec00.mspx

Mary