Macro to back up Database

[Samortensen]

Hello - I currently have many databases that I maintain and due to the importance of them, I back them up on a weekly basis. We have scripts that are kicked off through Windows task scheduler that opens these specific databases and updates them on an overnight run process. I want to take one of those scripts and rewrite it to run a macro in the database to back up the database with a date in the name.



The problem is, I thought that I could create this using an action out of the system commands - however, I am using Office 365 and I do not see the back up database command, nor do I see one called Copydatabaseobject in the action catalog as I read in some other posts here.

Does anyone have an idea as to how I can create this macro or if this is even possible?

[CJ_London]

We have scripts that are kicked off through Windows task scheduler that opens these specific databases

if you are using these, why not have one to copy the database to a backup location rather than open a db to run some code to effectively do the same thing?

[Samortensen]

Very good idea - unfortunately no one knows how to write it to tell it to do that.
Currently the script pertaining to the overnight process reads:

Dim db
Dim strDbName
dim strPassword
dim strMacro
strMacro = "** Run Spending Plan Database"
strdbName = "\\msp0ms01\pine bend project controls\Reporting\Databases\Spending Plan DB\Project_Portfolio_Reporting.accdb"
strPassword = ""
Set acc = createobject("Access.Application")
' this temporarily changes the macros security to low to avoid messages.
'onlt works with access 2000 onwards
if acc.syscmd(7) >= 10 Then
acc.AutomationSecurity = 1
End if

'if you do not need to see Access delete this line
acc.Visible = True
Set db = acc.DBEngine.OpenDatabase(strDbName, False, False, ";PWD=" & strPassword)
acc.OpenCurrentDatabase strDbName
acc.docmd.runmacro strMacro
db.Close

Would anyone know how to write one that could accomplish this? I certainly do not have that knowledge and so I thought a macro would suffice.