MS Access update a table with condition joining to another table

I need to update an MS Access 2003 database table based on a condition
I tried I tried
update tblA set Fld1 = B.Fld1 from tblA A inner join tblB B on A.Fld2 = B.Fld2 where B.Fld3 not in ( '000' , '001')

Also I tried options from following (It works for oracle. But not for Access)

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.