Back Up Ms Access Automatically

Lean Microsoft Access with us in 7 Days at : https://www.udemy.com/course/microsof...

Back up in Ms Access where the backing up will automatically take place as the user closes the database. The user will not even know or notice that a back up has been created or updated. In case your MS Access database is corrupt or has crushes, you will be able to restore from the most recent back up file.

Get the code below to run the Automatic BackUp
------------------------------------------------Code---------------------------------------------
Public Function CreateMyBackup() As Boolean
Dim Source As String
Dim Target As String
Dim a As Integer
Dim objFSO As Object
Dim Path As String
Path = CurrentProject.Path 'get location of current folder
Source = CurrentDb.Name
Target = Path & "\SalonAndSpass "
Target = Target & Format(Now(), "mm-dd") & ".accdb"

' create the backup
a = 0
Set objFSO = CreateObject("Scripting.FileSystemObject")
a = objFSO.CopyFile(Source, Target, True)
Set objFSO = Nothing
End Function
-----------------------------------------------------------------------------------------------

Visit our website: http://www.thetrainingfocus.com
Watch Video 1 video about the Power of Ms Access at :    • Developing Ms Access Applications fro...  
Watch Video 2 explaining the Ms Access Development Environment at    • Ms Access Developlment Environment-Le...  
Watch Video 3 on developing Ms Access tables from scratch at    • Create tables in Ms Access  
Watch Video 4 on developing Ms Access forms from scratch at    • Create Forms in Microsoft Access or M...  
Watch Video 5 on adding a picture on a form in Ms Access at    • Ms Access 5  - Adding Pictures On A Form  
Watch Video 6 on adding Ms Access Tab Controls on a form at    • Tab Controls On A Form in Ms Access  
Watch Video 7 on adding Ms Access Buttons on a form at    • Adding Buttons on A Form in Ms Access  
Watch Video 8 on designing an Ms Access SwitchBoard using a form at    • SwitchBoard Using A Form in Ms Access  
Watch Video 9 on designing an MS Access Query at    • Query Designing in Ms Access  
Watch Video 10 on designing MS Access Reports at    • Reports designing in Ms Access Reports  
Watch Video 11 on designing MS Access Plans and Schemas at    • Plans And Schemas in Ms Access  
Watch Video 12 on Importing and Exporting in Ms Access    • Importing Exporting in Ms Access  
Watch Video 13 on Ms-Access-Setting and Unsetting Password    • Setting and Removing Password from an...  
Watch Video 14 on Ms-Access-Adding-Formulea-in-Objects-Tables-Queries-Forms-Reports    • Adding Formulea in Ms Access Objects ...  

#MsAccessTraining #MsAccessDatabase #MsAccessTablesFormsQueries