Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Update failure on Access file under IIS on XP-PRO


Message #1 by mwhitmill@e... on Thu, 28 Mar 2002 03:18:47
I'm a novice on this platform but am nonetheless testing an existing 
ASP/JAVA application utilizing IIS to permit client and server operation 
on the same system.  When an attempt is made to update the ACCESS 
database, it fails.

The error reported is:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or 
object 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 
not enough.  I looked for attributes in the OBDC/DSN but couldn't find 
any.

Any help would be appreciated.
Thanks, Mike

  Return to Index