Depends on what your code is.
If you're just using VBA's FileCopy command, I believe the answer is no. I
think you'd have to use API calls to do the copy for you.
Randy Birch has an example at
http://vbnet.mvps.org/code/callback/filebackupcallback.htm
(Obligatory warning: Randy's site is aimed at VB programmers. There are
significant differences between the controls available for forms in VB and
in Access, so that Randy's examples usually cannot simply be copied into
Access. For example, in VB, you refer to the text contained in a text box by
using the Text property of the control. In Access, you can only use the Text
property if the control has focus: you either leave off the reference to the
property, or use the Value property instead)