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

On Fri, 21 Apr 2006 07:13:02 -0700, Pål Eilertsen <PlEilertsen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

¤ 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?
¤

Yes, you can link tables using a UNC path.

¤ 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 :)

Use My Network Places and drill down to Microsoft Windows Network. From there you should be able to
select the remote machine and shared resource.

The final key may be to enable impersonation. If it is not currently enabled then your app is
executing under the generic ASPNET account instead of IUSR (or IWAM).

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconimpersonation.asp


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)