Vba access to transfer files from one person to another

Hi Superusers

Hope you are all well.
I need your help please.
I need the transfer button in MS Access to transfer all the files from Employee A to another Employee please.

How to code the button transfer?

Thank you so much for your kind help

Need more info here?
Are we talking records not files?

thanks welshgasman. I had solved this problem but forgot to close it. Thanks a lot for your help.