adding to ms access

Originally posted by : Oscar (oscar.holmberg@telia.com)Why can't I add sentences or words to my database with the code below. I can only add numbers, why? Who do I do to fix this?Dim ConnectSet Connect = Server.CreateObject("ADODB.Connection") Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=c:database.mdb" x=61 For i=1 to 19 sql="update times set times=" & request("time" & i) & " where ID= " & x set recset=connect.execute(sql) x=x+1 nextConnect.CloseSet Connect = Nothing

Originally posted by : Enrico (piberg@casema.net)------------Oscar at 10/24/2001 11:20:55 AMWhy can't I add sentences or words to my database with the code below. I can only add numbers, why? Who do I do to fix this?Dim ConnectSet Connect = Server.CreateObject("ADODB.Connection") Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=c:database.mdb" x=61 For i=1 to 19 sql="update times set times=" & request("time" & i) & " where ID= " & x set recset=connect.execute(sql) x=x+1 nextConnect.CloseSet Connect = Nothing--------------------------------------------------hi, i'm not sure what you are trying to do, but just in case; did you check the property's of the field (in "design view") in wich you'r trying to write "time"?it should be "text", because the string "time" get an extra addition ("i") wich makes the value invalid for that field type. If the "time" string is lager than 255 characters, then set the field to "memo" in stead of "text".I hope this is what you mean, if not, ask again and i will try againregards enrico