syntax doing the same thing in sql server and vba sql

checking syntax from sql server 2008 to  vba Access query to do the same thing

I have this sql server 2008 sql:
Update ro set [Realign_Using_Trackcode] in ('XXXXX')
 from [ss_program_workflow].[dbo].[t_nsc_trackcode_reassign_overrides] ro
 where [Realign_Using_Trackcode] in ('ZZZZZ')

then i have this access query statement in sql:
UPDATE dbo_t_nsc_trackcode_reassign_overrides SET dbo_t_nsc_trackcode_reassign_overrides.Realign_Using_Trackcode = "ZZZZZ"
WHERE (((dbo_t_nsc_trackcode_reassign_overrides.Realign_Using_Trackcode)="xxxxx"));


are they doing the same thing ?


Thanks
fordraiders