AddNew Error

Results 1 to 2 of 2

Thread: AddNew Error

  1. #1
    Sharon Chandler Guest

    Default AddNew Error

    I am getting the following error when i try to add a record to my database.<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. <BR><BR><BR>I believe the DSN is working as i can view records ok and i have checked the security options of the database and all users have rights to add?. What other possible simple mistakes have i made &#060;g&#062;<BR><BR>Help would be much appreciated

  2. #2
    Join Date
    Dec 1969

    Default RE: AddNew Error

    The default LockType is a Read Only lock. This is why you are having problems, I&#039d wager.<BR><BR>Do this (make sure you include or use METADATA):<BR><BR>Dim objRS<BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Lo ckType = adLockOptimistic<BR>objRS.Open ... whatever you do here...<BR><BR>Hope this helps!

Posting Permissions

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