Back Up Ms Access Automatically

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.thetrainingfocus.com
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

[@mr.somchaivaroonchotikul5117]

Dear friend, your programming is very useful for me.

[@ladyouch18]

Thank you so much!

[@shahdtae439]

thank you very much

[@ssemaga]

Most welcome.

[@Hubris786]

Hi sir
This is very useful.
Can you please advise what shall I do to save the backup in different folder.

[@benjaminhegenderfer4457]

I tried to use this and I keep getting "User-defined type not defined" for the "a as interger". Do you know how to fix this?

[@abdullahss9710]

Thanks it is very good .. but i face problem
The tables in backup file it is linked not local table .. that mean if A problem with database the back of file will not work

[@ssemaga]

All tables must be local tables within the same database.

[@aramahmed6138]

Thank you, it's very useful, if the db split can use same way?

[@ssemaga]

Let me see how it works for split databases and revert.

[@sindusri-2463]

❤️❤️❤️

[@ssemaga]

Thanks

[@m.sknowledge7690]

can we set different location for backup?

[@ssemaga]

Yes, you can. Send me mail to guide you further.

[@user-gt1vn5io9h]

Is this for the back end of the database too?

[@ssemaga]

It is for both front and back end. But if your database is split, then you may consider have a form in the back end to trigger the event.