Hi Beacon,

Thank you very much for your help!! with rst.fields("Comments") = "" works!

I did it this way:

strdata = ""
rst.Fields("Comments") = ""
rst.Update

strdata = txtComments.Text
rst.Fields("Comments").AppendChunk strdata
rst.Update

i added these codes before the first strdata:

Set rst = New ADODB.Recordset
sql = "SELECT FileInfo.[Comments] FROM FileInfo WHERE FileInfo.FileName = " & selectedFile
Set rst = cnn.Execute(sql)

and i got this error: "Too few parameters. Expected 1"
What does it mean? I get this error for many other sql SELECT statements and i had to use this kind of code (rst.Open "UserInfo", cnn, adOpenKeyset, adLockPessimistic, adCmdTable) to do the work.

Why does this happen?