Re: Setting up Linked server to MsAccess

Thanks much for your response: I will try to explain the 'lashup'.

All of this is on a LAN

Box1: Win 2003 Server
Running SQLServer\Express
Containing folders with MSAccess Database X.mdb

SQl Express has linked server X mapped via UNC to Database X.mdb
Under the secrity tab for linked server X, I have selected "For
a login not defined in the list above, connections will:
ckbox, Be made using the login's current context.

Box2: Win 2000
Accessed via a RemoteDeskTop Connection by the User (logon/password)
With a WinApplication installed App1.exe
With a WebService installed in IIS WebService.amsx
App1.exe --> Calls the WebService for Data --> Passed to Box1
(SqlServerExpress)

If the user has full admin rights and opens IE, navigates to
http://localhost/WebService/WebService.asmx all the data calls work fine.
If the user does not have full admin rights .. same site.. then all the
data from the SQL server Database Tables work fine, but any views based on
the linked Access databases fail.

So to the best of my knowledge I'm failing to get proper Authencation passed
from the WebService -->SQL express --> the Mdb File.

The good news is I only need to 'read' the data from the Access Files, but I
need to do it in conjunction with a view based on the data in the Native SQL
Server database.
Something like "if its not in the SQLServer database then return a row from
the Access Database",

I hope some of this makes some sense, but there are just too many 'players
on the field' for me to figure this thing out.

Any help or ideas of where to look would be greatly appreciated.

Again, thanks for the help.

Ed Warren.






"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:7i298211tprekhgqu7mtirt1p893dga6lv@xxxxxxxxxx
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

  • Re: Is this possible??
    ... All our timekeeping data is stored on one server, ... This is the FoxPro database and that has all ... there is on a shared drive, each client has their own folder, we have around ... biggest concern though is how I'd be able to look up these Excel budget ...
    (microsoft.public.access.tablesdbdesign)
  • RE: DHCP Errors every hour? Looks serious!
    ... allow Indexing Service to index this folder" ... Antivirus software real-time scan the DHCP folder. ... Reinstall DHCP Services on the SBS server. ... | the DHCP database resides. ...
    (microsoft.public.windows.server.sbs)
  • RE: Windows server 2003 SP1
    ... I agree with Marina that you must keep the same server name to restore Exchange database. ... please also refer to the following KB articles for restore Exchange database. ... >Do the same for the public folder store ...
    (microsoft.public.windows.server.sbs)
  • Database Location in a Multitier Soulution
    ... By default if you add an Access database to a web project VS2005 likes to ... If you introduce the concept of a DataAccess layer ... DataAccess layer is compiled the DLL gets added to the Bin folder of the web ... workstation which happen to be redirected onto a different server (which is ...
    (microsoft.public.dotnet.framework.aspnet)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)