see thread :

http://forums.vb-world.net/showthrea...threadid=26433

Instead of using the update..from construct, use an update with a join (access has a sample in its documentation).