Hello Mike,

I've got the same problem. Did you find an answer by now? I know how to 
handle databases in ASP -- it's no problem -- but XP prevents every try to 
update.

Andre


> I'm a novice on this platform but am nonetheless testing an existing 
A> SP/JAVA application utilizing IIS to permit client and server operation 
o> n the same system.  When an attempt is made to update the ACCESS 
d> atabase, it fails.

> The error reported is:

> Error Type:
M> icrosoft OLE DB Provider for ODBC Drivers (0x80004005)
[> Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or 
o> bject is read-only.
/> reunion/addreservation.asp, line 95

> The associated code is:

>      set objConn =  Server.CreateObject("ADODB.connection")
 >     objConn.open "DSN=Invite2ReunionDB"

>      Set objRSreservations = Server.CreateObject("ADODB.recordset")
 >     ..
 >     ..
 >     objRSreservations.Update

> The last statement creates the error.

> I have set the file properties to include WRITE, but that was apparently 
n> ot enough.  I looked for attributes in the OBDC/DSN but couldn't find 
a> ny.

> Any help would be appreciated.
T> hanks, Mike

I've got the solution!

You have to edit the folders rights. XP-Pro forgets to give the folder 
writing-rights for the anonymous internetuser IUSR_<computername>. Reboot 
the system after the changes an it will work.

A good thing under XP Pro is to give rights to the group: Authenticated
Users
The anonymous acount is part of that and that way, if you have users log
in with an NT accounts, they ALSO can write to the database!

Gr,

Jeroen Diderik

-----Original Message-----
From: Andre Schuessler [mailto:schuessler@s...]
Sent: Tuesday, May 14, 2002 5:59 PM
To: Access ASP
Subject: [access_asp] Re: Update failure on Access file under IIS on
XP-PRO


I've got the solution!

You have to edit the folders rights. XP-Pro forgets to give the folder
writing-rights for the anonymous internetuser IUSR_<computername>.
Reboot
the system after the changes an it will work.