I am using vbscript to insert & update ms accees.

Insert operation is working , but update operation is not working.

I have used the following codes:


Code:
connectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\progam files\mail.mdb"


Code:
 

If (CStr(Request("MM_insert")) = "regorg") Then
    
  ConnectionDb = connectionString

  MM_editTable = "Reg"

 MM_fieldsStr  = "username|value|email|value| "

 MM_columnsStr = "username|',none,''|email|',none,''"


  ' create the MM_fields and MM_columns arrays

  MM_fields = Split(MM_fieldsStr, "|")

  MM_columns = Split(MM_columnsStr, "|")


  ' set the form values

  For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2

    MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i)))

  Next

  ' append the query string to the redirect URL

  If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then

    If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then

      MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString

    Else

      MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString

    End If

  End If

End If

‘ insert & update record
Code:
 

Dim MM_tableValues

Dim MM_dbValues, sql , id

id = Recordset1.Fields.Item("userid").Value

sql = ""


sql="UPDATE customers SET "

If (CStr(Request("MM_insert")) <> "") Then

  MM_tableValues = ""

  MM_dbValues = ""

  For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2

    MM_formVal = MM_fields(MM_i+1)

    MM_typeArray = Split(MM_columns(MM_i+1),",")

    MM_delim = MM_typeArray(0)

    If (MM_delim = "none") Then MM_delim = ""

    MM_altVal = MM_typeArray(1)

    If (MM_altVal = "none") Then MM_altVal = ""

    MM_emptyVal = MM_typeArray(2)

    If (MM_emptyVal = "none") Then MM_emptyVal = ""

      If (MM_formVal = "") Then

        MM_formVal = MM_emptyVal

      Else

        If (MM_altVal <> "") Then

          MM_formVal = MM_altVal

        ElseIf (MM_delim = "'") Then  ' escape quotes

          MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'"

        Else

          MM_formVal = MM_delim + MM_formVal + MM_delim

        End If

      End If

      If (MM_i <> LBound(MM_fields)) Then

        MM_tableValues = MM_tableValues & ","

        MM_dbValues = MM_dbValues & ","

      End If

      MM_tableValues = MM_tableValues & MM_columns(MM_i)

      MM_dbValues = MM_dbValues & MM_formVal


      sql=sql & "MM_tableValues='" & MM_dbValues & "',"

  Next

   sql=sql & " WHERE userid ='" & id & "'"
If (Not MM_abortEdit) Then


' insert operation is not creating a problem

Code:
 

  ' execute the insert

    Set MM_editCmd = Server.CreateObject("ADODB.Command")

   MM_editCmd.ActiveConnection = ConnectionDb    

   MM_editCmd.CommandText = MM_editQuery

    MM_editCmd.Execute 

    MM_editCmd.ActiveConnection.Close
update operation is not working

Code:
 

‘ execute the update

Set MM_editCmd = Server.CreateObject("ADODB.Command")

   MM_editCmd.ActiveConnection = MM_editConnection

   MM_editCmd.CommandText = sql

    MM_editCmd.Execute 

    MM_editCmd.ActiveConnection.Close