Can I create an autoexec macro to backup a database

[mdnikki]

I have created a database that a few people will be working in at different times. I would like a back up of the database created each time it is opened. Is it possible to create an autoexec macro to run that creates this. Or is there another way to have this db backed up each time.

Thanks


Nicol

[ranman256]

In the autoexec ,RUNCODE myBackup()

put this function in a module...

function myBackup()
VDate= format(date,"yyyymmdd-hhnn")
vSrc="c:\folder\myDb.accdb"
vTarg="c:\folder\ backup\myDb-" & vDate & ".accdb"
filecopy vSrc,vTarg
end function

[JoeM]

If you have multiple users, and are worried about corruption, the very first thing you should do (if you have not done it already) is to split database.
See: https://support.office.com/en-us/art...3-51b1d73498cc

If your concern is more about the data getting changed and you want the original data, I would go about what you want to do a little differently.
Create a batch file or VBS Script and give to the users to "run the program", and simply have the batch file/script do the following:
- Create a copy of the back-end
- Open the front-end

Note that depending on how big your database is and how often people are going into it, this could suck up a lot of memory, unless you periodically purge old backups.

[CJ_London]

not sure if filecopy will work if you are trying to copy a file that is open (i.e. the currentdb or the backend). If it doesn't, try something like (using variables from Ranmans code)

Shell "cmd /c copy """ & vsrc & """ """ & vtarget & ""