What is an Updateable Query?

Results 1 to 2 of 2

Thread: What is an Updateable Query?

  1. #1
    Join Date
    Dec 1969

    Default What is an Updateable Query?

    I&#039m trying to insert a new record into a login database using the following code and I get the error listed below the code. Can anyone tell me what this means? I had this working fine on a win98 box but it gives me an error when run on my NT machine.<BR><BR>sql = "INSERT INTO logindata(StudentID, LoginName, Password, "<BR> sql = sql & "FirstName, LastName, Email) "<BR> sql = sql & "VALUES( &#039"<BR> sql = sql & Request("student_id") & "&#039,&#039"<BR> sql = sql & Request("loginname") & "&#039,&#039"<BR> sql = sql & Request("password") & "&#039,&#039"<BR> sql = sql & Request("first_name") & "&#039,&#039"<BR> sql = sql & Request("last_name") & "&#039,&#039"<BR> sql = sql & Request("email") & "&#039)"<BR><BR>Set OBJdbConnection = Server.CreateObject("ADODB.Connection")<BR>OBJdbCo nnection.Open "source_db"<BR>OBJdbConnection.Execute(sql)<BR>OBJ dbConnection.Close<BR><BR>THE ERROR____________________<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query. <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: What is an Updateable Query?

    I have the same problem: what works on one NT server doesn&#039t work on another.

Posting Permissions

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