Lean Microsoft Access with us in 7 Days at : www.udemy.com/...
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: www.thetraining...
Watch Video 1 video about the Power of Ms Access at : • Developing Ms Access A...
Watch Video 2 explaining the Ms Access Development Environment at • Ms Access Developlment...
Watch Video 3 on developing Ms Access tables from scratch at • Create tables in Ms Ac...
Watch Video 4 on developing Ms Access forms from scratch at • Create Forms in Micros...
Watch Video 5 on adding a picture on a form in Ms Access at • Ms Access 5 - Adding ...
Watch Video 6 on adding Ms Access Tab Controls on a form at • Tab Controls On A Form...
Watch Video 7 on adding Ms Access Buttons on a form at • Adding Buttons on A Fo...
Watch Video 8 on designing an Ms Access SwitchBoard using a form at • SwitchBoard Using A Fo...
Watch Video 9 on designing an MS Access Query at • Query Designing in Ms ...
Watch Video 10 on designing MS Access Reports at • Reports designing in M...
Watch Video 11 on designing MS Access Plans and Schemas at • Plans And Schemas in M...
Watch Video 12 on Importing and Exporting in Ms Access • Importing Exporting in...
Watch Video 13 on Ms-Access-Setting and Unsetting Password • Setting and Removing P...
Watch Video 14 on Ms-Access-Adding-Formulea-in-Objects-Tables-Queries-Forms-Reports • Adding Formulea in Ms ...
#MsAccessTraining #MsAccessDatabase #MsAccessTablesFormsQueries
Негізгі бет Back Up Ms Access Automatically
Пікірлер: 18