HELP! What is Error 80004005, "Row Error"

Results 1 to 2 of 2

Thread: HELP! What is Error 80004005, "Row Error"

  1. #1
    Join Date
    Dec 1969

    Default HELP! What is Error 80004005, "Row Error"

    Why won&#039t this code Add a new record to the Access database?<BR><BR>Sub Update<BR>set oConn=Server.CreateObject("ADODB.connection")<BR>S et oRS = Server.CreateObject("ADODB.recordset")<BR>oConn.Op en "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=F:Replica of EagleRock.mdb"<BR> "Clients",oConn,adOpenKeyset,adLockPessimistic,adC mdTable <BR><BR>oRS.MoveLast<BR>oRS.AddNew<BR>oRS.Fields(" Email") = Email<BR>oRS.Fields("First") = FirstName<BR>oRS.Fields("Last") = ""<BR>oRS.Fields("Phone") = ""<BR>oRS.Fields("Address") = ""<BR>oRS.Fields("City") = City<BR>oRS.Fields("State") = ""<BR>oRS.Fields("Zip") = ""<BR>oRS.Fields("Interest") = Interest<BR>oRS.Fields("Status") = "Active"<BR>oRS.Fields("Date") = Today<BR>oRS.Fields("Time") = Now<BR>oRS.Update<BR>oRS.Close<BR>Set oRS=Nothing<BR>oConn.Close<BR>Set oConn=Nothing<BR>End Sub

  2. #2
    Scott S Guest

    Default RE: HELP! What is Error 80004005,

    Does the record you are trying to enter satisfy all relavent constraints & foriegn key relationships? what was the error exactly? I would check the database, see if everything is working, try entering that record directly into the database. If that works you can isolate the error, it would be in your code.<BR><BR>Try to debug in stages, first check the db, second the stored procs (not relavent for access), third the asp code (and or object code).<BR><BR>Scott S

Posting Permissions

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