Programming questions? Ask a programmer for answers ASAP
Hello, I'm Tim and have over 17 years of experience with eBay, Google, and the Department of Defense. Please tell me more about your problem, the more detail, the better.
You mean you want to automate it?
You can go to File, select Backup, and then save the back up file. You can automate that in a batch script or using AutoHotkey.
OK, so I can connect remotely (only on windows based machines), please click the link below, hit yes and download and open the software and hit run.
hmm, OK let me reset it.
what programing language are you writing in by the way?
You can include this as a subscript the below:
Public Sub backupBackend() Dim TestFile As String Dim strReplFile As String Dim copyFromLocation As String Dim copyToLocation As String copyFromLocation = "S:\Trust 2 Analysis\Data" ' set the file name and location of the file to copy copyFromLocation = copyFromLocation & "\trust2_be.accdb" 'set the location/name of the file that will be written copyToLocation = "S:\Trust 2 Analysis\Data\Backups\trust2_be " & Format(Now(), "dd-mm-yy hh-mm-ss") & ".accdb" ' set the file name of the batch file to create TestFile = CurrentProject.Path & "\BackupDbBE.cmd" ' create the batch file Open TestFile For Output As #1 Print #1, "Echo Off" Print #1, "ECHO Backing up database" Print #1, "" Print #1, "ECHO Copying file to backup folder" Print #1, "Copy /Y """ & copyFromLocation & """ """ & copyToLocation & """" Print #1, "" Print #1, "DEL " & """%~f0""" Close #1 ' run the batch file Shell TestFile End Sub
".I need to back up an Access 2016 "
It should be similar. What are you coding in?