Re: Access To Access

Paul W Smith wrote:
> Bob,
>
> Thank for your help.
>
> I have read the references below and tried to understand but as a
> simple developer it is all too complicated for me. The principles
> are not but I am not confident about making changes to internal
> accounts.
> I am using Windows XP Professional. I cannot find how to change
> security through Windows Explorer although references seem to think I
> should be able to.

You need to shut off "simple file sharing". Form this article,
http://www.aspfaq.com/show.asp?id=2205, this is the relevant paragraph:

Now, what if you don't have a Security tab?

Open up Windows Explorer, open the Tools menu, choose Folder Options, and go
to the View tab. The last item in the list is called "Use simple file
sharing." Uncheck this box, click Apply and OK, and try the above steps
again


>
>
> Using Computer Management from Control Panel I can see the users and
> groups on my PC. I think I have to add IUSR_<machinename> and
> IWAN_<machinename> to a group which given them the required permissions.

No. After shutting off "simple file sharing", navigate to the folder
containing the database, then, from that same article:

In Windows Explorer, right-click the folder in question, hit Properties, and
select the Security tab. If the Internet Guest Account (IUSR_<machinename>)
is not listed, click the Add... button and type IUSR_<machine_name> into the
textbox, and click OK. Now select the Internet Guest Account, and check that
the permissions are adequate. For most web applications, Read and Write is
sufficient. You may have to do this for individual files as well, and for
Access databases specifically, you might also have to open up the temp
folder. You can see Article #2039 for more detailed instructions and setting
up permissions for IUSR.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.