Why is this recordset read-only?

Results 1 to 2 of 2

Thread: Why is this recordset read-only?

  1. #1
    Join Date
    Dec 1969

    Default Why is this recordset read-only?

    I am trying to make an update to a recordset, but the Access 97 driver is saying that the recordset is read-only. I can&#039;t figure out why it is readonly: <BR><BR>strSQL=<BR>SELECT timesheet.*,ComponentProject,ComponentID FROM timesheet, Component WHERE (ComponentProject = 62) AND (ComponentID = timeComponentID) AND timeEntryDate &#060;= #7/18/01 4:09:29 PM# ORDER BY timeEntryDate<BR><BR>I then open the recordset with:<BR>objRS.open strSQL,objConn,adOpenStatic,adLockPessimistic,1<BR ><BR>upon trying to make an update, i receive the error:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e21&#039;<BR>[Microsoft][ODBC Microsoft Access 97 Driver] Can&#039;t update. Database or object is read-only.<BR><BR>any ideas?<BR>thanks,<BR>cory<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Joins can not be updated <eop>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts