>Good afternoon!
>I'm having the following error message when I try to .update a recordset.
>I have been looking at the code for hours and still can not figure out why is not working.
>
>Any help is appreciated!.
>
>Erro message:
>'Insufficient result space to convert uniqueidentifier value to char'.
>
>Here is my code for connection and recordset.:
>

>Option Explicit
>Dim cnnPhoneSQL As ADODB.Connection
>Dim rstPhonesSQL As ADODB.Recordset
>Dim strSQL As String
>Private Sub Form_Load()
>
>'creating a connection
>Set cnnPhoneSQL = New Connection
>With cnnPhoneSQL
>    .Provider = "SQLOLEDB"
>    .ConnectionString = "User ID = sa;" & _
>                     "Data Source = WEBDEV;" & _
>                     "Initial Catalog = Phone"
>    .Open
>End With
>
>'Creating recordset
>Set rstPhonesSQL = New Recordset
>With rstPhonesSQL
>    .CursorType = adOpenDynamic
>    .LockType = adLockOptimistic
>    .CursorLocation = adUseServer
>    .Open "SELECT * FROM Phones ORDER BY name ASC", cnnPhoneSQL
> End With
>
>'Populate textbox
>Set txtLastName.DataSource = rstPhonesSQL
>txtLastName.DataField = "last_name"
>
>End Sub
>Private Sub cmdAdd_Click()
>    rstPhonesSQL.AddNew
>End Sub
>Private Sub cmdSave_Click()
>    rstPhonesSQL.Fields("last_name") = Trim(txtLastName.Text)
>    rstPhonesSQL.Update
>End Sub
>

>Thanks,
>

Try setting your cursor client side:
.CursorLocation = adUseClient