Re: Setting up Linked server to MsAccess

It's difficult to figure out what the possible issues are as
"only works for some users" say much.
What are the specific error messages and what application
are the users using when they get the messages? Where is the
access file located - on a UNC share, on the SQL Server box,
etc. Do you have any security implemented for the Access
database?

-Sue

On Sun, 4 Jun 2006 13:24:15 -0500, "Ed Warren"
<eowarren@xxxxxxxxxxxxxxx> wrote:

I'm stumped by the security issues around setting up a microsoft access
database as a linked server.
I only need to read the data, I don't need to write back to the database.

I've followed the wizards in the Management Studio and have set up the
Access File as a Linked server, however, it only works for 'some' of the
users.
I've checked the folder permissions and the 'failed' users are memebers of a
group with full permissions to to folder, so the problem does not appear to
be at the folder level.

So, I need a simple step by step on how to walk through the SQL Server
Management Studio and set up the permissions as required to read the
database files.

Thanks,

Ed Warren.


.

Relevant Pages

  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie: I dont understand user permissions for table access
    ... > My database is remote to my workstation. ... > tables/fields WITHOUT specifying anything in the permissions dialogs? ... >> HOW are you connecting to SQL Server? ... what rights/permissions have been granted to the PUBLIC role? ...
    (microsoft.public.sqlserver.server)
  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server is creating a job behind the scenes. ... SA account password and gaining access to the database. ... > SQL Server doesn't check permissions on indirectly referenced objects as ... > the proxy account security context for non-sysadmin users from Enterprise ...
    (microsoft.public.sqlserver.security)
  • Re: Security question ..
    ... What I want to prevent is any access to the database accept through our ... application unless you have elevated permissions. ... Authentication, if he is smart enough to create an NT Auth ODBC connection ... passes through to the database or to use SQL Server authentication. ...
    (microsoft.public.sqlserver.server)