Re: Error accessing MS Access database with Linked Tables on files

Hi,

Thanks for your answer... on both forums :)

I actually feel I have tried all the things you mention here except the part
of using UNC path. Can this be done when linking tables in MS Access?

How can I check that my app is running under the local anonymous account? I
have set IIS 5.0 to use Anonymous access and have the web app to use forms
authentication. The anonymous account is IUSR_<machinename> with a password
that I have set (unchecking the "Allow IIS to control passwords" checkbox).
On the remote machine I have created a user account with the same name as
IUSR on the webserver and also set the same password. I have then entered the
user into a group that has all priviliges on the shared drive.

I have also tried to use another account that was allready on both machines,
without any luck. I am not running a domain and have all PC/servers set for
workgroup.

And all the above said I have tried a similar setup on my local machine with
with the linked tables on a share and it all worked fine. The difference
being as mentioned before. Only difference is that I am logged on the
developer machine with an account that has the same username and password on
the share. So for me it seems to be a IIS 5.1 to IIS 5.0 problem.

But I will try once again to do everything you suggests in order to be sure.
Firstly to try to use UNC paths in Access when linking. Not that I know how
to do this though :)

Again, thanks for the answer and support.

Best regards
Pål Eilertsen

"Paul Clement" wrote:

On Fri, 21 Apr 2006 01:42:01 -0700, Pål Eilertsen <PlEilertsen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

¤ Hi,
¤
¤ I have a ASP.Net application that uses a MS Access database. The site works
¤ fine when all databases resides locally but on my public server I need to use
¤ a different database where the main databasefile resides locally but also has
¤ tables linked that resides on a fileshare/network drive.
¤
¤ When I try to run my app I know get an:
¤ 'database.mdb' is not a valid path. Make sure that the path name is spelled
¤ correctly and that you are connected to the server on which the file resides.
¤ The database.mdb file is one that resides on the fileshare.
¤
¤ I suspect that this has something to do with permissions on the remote
¤ machine but I don not understand what I need to do. I have tried to use
¤ impersonation by adding the <identity impersonate="true" /> tag to the
¤ web.config file but that only seems to work on my win XP machine running IIS
¤ 5.1. When I try to do the same on the server (Win2K running IIS 5.0) I get an
¤ "Unspecified error" when calling Connection.Open().
¤
¤ Does someone know a solution? Am I even posting this on the right forum?

Well yes this is probably the appropriate group although I did reply in the vb.database group. We
can pick it up here if you would like. Here were my responses:

If the app is running under the local anonymous account you must have an identical local account
with the same credentials (user ID and password) on the remote machine. This will enable you to
delegate security to the remote machine.

An alternative delegation scenario would be to change the anonymous account under which the app runs
(in IIS) to a domain account (assuming that both machines are in the same domain - if you have one).

I should have mentioned a couple of other issues. First you should be using a UNC path instead of a
mapped drive letter for your linked tables.

Second, you should enable impersonation for the ASP.NET app if you want to delegate security for the
default anonymous account or a selected domain account. Otherwise, the default ASP.NET account will
be delegated (which is ASPNET under Win2K and WinXP).


Paul
~~~~
Microsoft MVP (Visual Basic)

.

Relevant Pages

  • Re: Error accessing MS Access database with Linked Tables on files
    ... ¤ Thanks for your answer... ... How can I check that my app is running under the local anonymous account? ... So for me it seems to be a IIS 5.1 to IIS 5.0 problem. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Starange behavior in XP limited account
    ... Maybe it's because it instantiates an instance of Word and PowerPoint and they had only previously been run on another admin account. ... For further troubleshooting I'll have to create a new virgin install of XP and clone it. ... ¤ limited user account in XP SP2. ... small window (not generated by my app) popped up with "Microsoft Platform ...
    (microsoft.public.vb.general.discussion)
  • Re: ldap connection problem
    ... Thanks again Paul. ... also tried using a domain user account to run the web ... > ¤ I tried implementing the primary token thing but it is of no avail. ...
    (microsoft.public.dotnet.general)
  • RE: debugging ASP NET in a remote web server with remote file serv
    ... this is likely a typical remote access problem. ... In IIS virtual dir's Home directory setting panel, when we specify UNC ... That is used to specify an account to ... connect to that UNC path from your local box. ...
    (microsoft.public.vsnet.debugging)
  • Re: Could not find a part of the
    ... access that share *and* use the UNC path to access it. ... mapping is for *your* account, which is not the account the ... You might need to van the site impersonate some domain-user that *can* ...
    (microsoft.public.dotnet.framework.aspnet)