Auto Save of Access Database to different location

[Mearntain]

In my access database, I have a homepage which has an "exit program" button that closes access all the way down. What I would like to do, if possible, is when this exit button is pressed, that a copy of this access database is placed in a designated location. So not only would my database be constantly updating to its original location as records are updated, but when the exit button is pressed ( and only when the exit button is pressed), a second copy of the file is placed at a 2nd location. I'm half decent with VBA, but this is beyond the scope of what I know. Thanks in advance!

[ranman256]

in the EXIT button, the code should have
DoCmd.Quit

BEFORE this statement, put the file copy
FILECOPY src, target

[Mearntain]

I tried using this before, but I always get Permission Denied error message. Do you know why this is? I have permissions to all the target locations I have tried. I have tried sending it to the network directly, mapped drives on the network, and straight to my C drive. None will work. I am using:

FileCopy "C:\Users\davidr\Desktop\dept 40 log.mdb", "\\MGEADC1\Manuf-Eng\Rowe\WCWT"

[JamesDeckert]

try copying a different source file. If that works, then it's probably because you access file is locked.
Do you have front end/back end or a single file?
you may be able to delete the .ldb file and then do the copy.

[Mearntain]

I ended up using the code below, and have everything working great now. Thanks for the input from you both!

  Dim xlobj As Object    Set xlobj = CreateObject("Scripting.FileSystemObject")
    xlobj.CopyFile "C:\Users\davidr\Desktop\dept 40 log.mdb", "\\MGEADC1\Manuf-Eng\Rowe\dept 40 log.mdb", True
    Set xlobj = Nothing