Microsoft JET Database Engine error '80004005

Results 1 to 3 of 3

Thread: Microsoft JET Database Engine error '80004005

  1. #1
    Join Date
    Dec 1969

    Default Microsoft JET Database Engine error '80004005

    Hi,<BR>What you know about this error:<BR>Microsoft JET Database Engine error &#039;80004005&#039; <BR><BR>Operation must use an updateable query. <BR><BR>/mail_ac.asp, line 24 <BR><BR>bye<BR><BR>RELATED CODE :<BR>&#060;%<BR> <BR> Dim email, con, data_source, sql_insert, sql_check, rs<BR><BR> email = Request.Form("email")<BR> <BR> If Len(email) Then<BR><BR> <BR> data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _ <BR> Server.MapPath("haber.mdb")<BR> <BR> sql_check = "select email from users where email = &#039;" & email & "&#039;"<BR> sql_insert = "insert into users( email ) values (&#039;" & email & "&#039;)"<BR><BR> <BR> Set con = Server.CreateObject("ADODB.Connection")<BR> con.Open data_source<BR> Set rs = con.Execute (sql_check, , 1)<BR> <BR> If rs.EOF Then<BR> con.Execute sql_insert<BR> <BR> Response.Write "Thank you. Your email address &#060;b&#062;" & email & _<BR> "&#060;/b&#062; was successfully entered into the database"<BR> <BR> Else<BR> Response.Write "Your email address " & email & _<BR> " is already present in the database. Thank you."<BR> End If<BR><BR> <BR> con.Close<BR> Set con = Nothing<BR> <BR> Else<BR> <BR> Response.Redirect "haber.htm"<BR> End If<BR> %&#062;<BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Microsoft JET Database Engine error '8000

    Not sure because that error message can mean a lot of things. @ suggestions.<BR><BR>1) Use a dsn-less connection like this<BR><BR>strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("haber.mdb")<BR><BR>set conn = server.createobject("adodb.connection")<BR>conn.op en strconn<BR><BR>set rs = server.createobject("adodb.recordset")<BR><BR>then you code<BR><BR>2) "If Len(email) Then" "If len(email).... WHAT??? That&#039;s not a complete statement.<BR>

  3. #3
    Join Date
    Dec 1969

    Default SEe the ASPFAQs.

    Category "Database Errors"

Posting Permissions

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