Hello

I develop data driven sites using Dreamweaver MX and MSAccess. I set
up IIS on my WinXP Pro machine in order to test locally before
uploading to the final server on the Internet. When testing sites
(locally) I can see HTML pages as well as ASP pages. I can browse
through the entire sites and I can see the database contents. BUT I
can not add, modify or delete any records. I made sure the database
file had the right read/write permissions but I have had no luck. I
even uninstalled and reinstalled IIS but I still get the same error.
This is the error I get:

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable query.
/plife/backoffice/compras/marcar_revisada.asp, line 81

This is line 81:     MM_editCmd.Execute();

I would appreciate your help!

It's most likely a permission problem.  If this page is running
anonymously, make sure the IUSR_ account has read/write to the FOLDER
in which your access file resides.  It needs to write the lock file
(ldb) when doing updates/deletes.

I made sure permissions are set correctly to both the database itself
and the folder in which the DB is located, they both have read/write
permissios

is there a way to specifically set permissions to the IUSR_user?

any other idea?

ok... done with this one

I was setting read/write permissions on IIS but I was not sharing the
folder & file over the network to permit other users to modify it. I
did this directly on Windows Explorer.

Took me some time to figure it out!