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

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
    ... of using UNC path. ... How can I check that my app is running under the local anonymous account? ... that I have set (unchecking the "Allow IIS to control passwords" checkbox). ... ¤ I have a ASP.Net application that uses a MS Access database. ...
    (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: Using MAPIControls with VB6
    ... What happens when the client does not use Outlook Express? ... As I said my app that uses MAPI controls through Outlook Express works ... with the one exception of being able to specify the account; ... ¤ Hi, ...
    (microsoft.public.vb.general.discussion)
  • Re: Using MAPIControls with VB6
    ... As I said my app that uses MAPI controls through Outlook Express works quite ... If there is no more cost effective way of specifing a given account in the ... ¤ Hi, ...
    (microsoft.public.vb.general.discussion)