I am having a serious problem with getting the add user to work in chapter 14. I have copied the example files from the code download and even run i ruyn that i get this error

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Click the Refresh button, or try again later.

Open the localhost home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/thesoccersite/admin/updateEvent.asp, line 131


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)

Page:
POST 292 bytes to /thesoccersite/admin/updateEvent.asp

POST Data:
Title=Chicago+Fire+-+New+England+Revolution&Summary=Chicago+Fire+again st+New+England+Revolution+at+the+Gillette+Stadium& EventDescription=Chicago+Fire+against+New+England+ Revolution+at+the+Gillette+Sta . . .

Time:
Tuesday, August 19, 2003, 7:00:19 PM

I get the same error when i try to edit a user aswell, and deleting a user does not work either.
However all the authentication and viewing the contents of the database does work, just not adding, editing and deleting.
Please can someone help?
Thanks and have a good day!

Hi Pat,

Adding a user?? I though the chapter was about adding events?? ;)

Anyway, the "Operation must use an updateable query" error usually indicates a permissions problem on the .mdb database.

Make sure that the IUSR_MachineName account has sufficient rights to update the database. Setting change rights for the .mdb file is not enough. You'll also need to set change rights to the folder the database resides in (Database). At run-time, an .ldb (lock) file is created, so IUSR_MachineName needs the rights to change the Database folder.

If you're not using anonymous access, make sure the account you use to log on to the website has sufficient rights.

HtH

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.