Access Linked Tables Rights issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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.
 
Back
Top