Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: Error number = 2147467259, Error Description = Operation must use an updateable query

    Please help me to sove this problem.

    I want to use the INSERT INTO sql statement in MS ACCESS and ASP and and used the following query

    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open(Server.Mappath("Travel.mdb"))
    sql="INSERT INTO Tmp_Hotel (Mem_id,Hotel_id,credit_num)"
    sql=sql & " VALUES "
    sql=sql & "('" & nmemid & "',"
    sql=sql & "" & nhotelid & ","
    sql=sql & "" & ncrednum & ")"

    on error resume next
    conn.Execute sql,recaffected

    But, i have the abouve error and please help me how to solve.

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138

Posting Permissions

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