Setting up Linked server to MsAccess

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

  • Re: Linking to a database which is in use
    ... This is probably a permissions problem on the directory in which the backend is ... See ACC: Determining Which User Has Opened Database Exclusively ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: can not open MDB file
    ... > To remove User-Level security on your Microsoft Access ... > that defines security for the database that is secured. ... Grant full permissions to the Users group and the Admin user account ...
    (microsoft.public.access.security)
  • Re: Front End Opens Backend Exclusive
    ... database in the morning and the backend is being opened exclusively by ... save and delete a notepad file. ... I strongly suspect their permissions are inadequate. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: import security definitions
    ... Microsoft Access MVP ... can not select a table to copy the permissions to.. ... DB1 is owned by Administrator (I have to take the permissions of this ... to copy the permissions from the old database to the new database. ...
    (microsoft.public.access.security)
  • Re: Front End Opens Backend Exclusive
    ... database in the morning and the backend is being opened exclusively by ... save and delete a notepad file. ... I strongly suspect their permissions are inadequate. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)