Results 1 to 3 of 3

Thread: Update?

  1. #1
    Martin, Sweden Guest

    Default Update?

    I have an Access db, with one table that contains just one field!<BR><BR>table name = news<BR>table field name = data<BR><BR>I want to use the SQL statement UPDATE to replace information in the table field, with some new information!<BR><BR>Now I have to delete the first row in "data", and then insert a new row!<BR><BR>Are you able to use the UPDATE command to replace the information i the "data" field with some new information?<BR><BR>Please help me out dudes!<BR><BR>Thanks! <BR>

  2. #2
    dclark Guest

    Default RE: Update?

    Just write an SQL UPDATE statement to a variable then use the connection object execute command to do the update.<BR><BR>strSQL = "UPDATE dbtable SET field1 = &#039value&#039"<BR><BR>set dbConn = server.createobject("ADODB.Connection")<BR>dbConn. open connectionstring<BR>dbConn.execute strSQL<BR>dbConn.Close<BR>set dbConn = nothing

  3. #3
    Martin, Sweden Guest

    Default Thanks (dclark) !!!

    Really kind of ya!<BR><BR>Thanks<BR>Martin, Sweden<BR>

Posting Permissions

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