[thelist] asp ... I'm beginneing to believe one can't really update a record using it! :(

[Joel Morris]

Hi Laura --

You are correct - it is most likely a "permissions" problem.

You need to set "write" privileges in IIS on the directory where your
Access database resides, and on the Access database. Since you don't
want anybody to just download the database, you should deny "read"
privileges on that directory as well.

I usually put the database in its own directory by itself so you're
not denying "read" ability on regular web pages.

These are settings in IIS - not your ASP code - so that is where you
can modify those settings.

Let me know if you need any further help (IIS is not my area of
expertise, but I can usually click and un-click things until I get it
right).

Best, Joel Morris
-------------------------------
CityCenter Co.
Website Development & Marketing
http://www.citycent.com
mailto:joelm at citycent.com



> The message I get is:
> Microsoft JET Database Engine (0x80004005)
> Operation must use an updateable query.
>
> Having searched on this error message, there seems to be a
> wide consensus
> the problem is
>
> IUSR_MACHINENAME and what I must do is provide this entity
> with some more
> permissions.
>
> Good enough.
>
> After hours of web-searching, the only pertinent advice on
> HOW TO improve
> IUSR_MACHINENAME's permission, is to ask your internal web guy.
>
> Being an organization of one, I asked myself and got no
> coherent answer.
>
> There was only one other piece of advice I could get, and
> this advice - lots
> of sites concurred. That is "giving permissions is dangerous to do.
>
> thanks, Laura