A problem updaating a field

[jakeir]

Hi,
I am tring to update a field in the a sql server 2005 databse. I am useing the code below to update a field in a table, and while it works for every field two of them it will not work. Comes back saying trying to update an un updateable field.
There are no trigers or constrants on the table so I am not sure why I am getting this, if anyone as some ideas I would really apprecite it.
Thank you

Here is my code: (Changed_by this is a nvarchar field)

StrSql1 = "Update [Account_Exec] Set Changed_by = '" & U & "' Where
Rep_Id = '" & txtRep_Id & "'"
DoCmd.RunSQL StrSql1

The other field: (Changed a date field)

StrSql1 = "Update [Account_Exec] Set Changed = '" & Now() & "' Where
Rep_Id = '" & txtRep_Id & "'"
DoCmd.RunSQL StrSql1


here is the same code on another field and it works:

StrSql1 = "Update [Account_Exec] Set Rep_First_Name = '" &
Me.txtRep_Last_Name & "' Where Rep_Id = '" & txtRep_Id & "'"
DoCmd.RunSQL StrSql1

 

[randy700]

The delimiter for a date field is the # symbol. Try...

StrSql1 = "Update [Account_Exec] Set Changed = [b][COLOR=red]#[/color][/b]" & Now() & "[b][COLOR=red]#[/color][/b] Where
Rep_Id = '" & txtRep_Id & "'"

In the first query, what is U.



Randy

 

[jakeir]

U is the user, that I insert above. I was trying to put the # sign in but I kept puting it in the wrong place. Thanks it now works.
Thank you