Create a backup of the back end from teh front end 1

[jonney]

Hi

I am trying to automate the process of creating a backup of the back end (datafiles) from the front end to ensure users do not lose data as part of a procedure.

Hope someone can help

Jonney

 

[Ed2020]

I'd ensure it was run from an unbound form and no other users are in the system (to ensure the backend is not being accessed) and use the FileCopy command to create a copy of the file in a separate location.

Ed Metcalfe.

Please do not feed the trolls.....

 

[ClydeData]

I use Idrive

http://www.idrive.com/

to automate the backup and send file of site.

You can leave the srver on and set one of the PCs to do the backup using Idrive out of office hours

Hope This Helps

Jimmy

 

[JerryKlmns]

Scripting.FileSystemObject allows to copy a file while in use,
FileCopy wont!

But durring nighthours you could use a scheduled task that runs a bat file which copies the mdb