How to Create AUTO BACKUP in Microsoft Access

This video will show you on how to backup your Ms Access database file on a simple way.
Downloadable Templates:
• Free Download Template
👍 Please Like comment and share to support this channel
ua-cam.com/users/c...
Keywords:
How to create auto backup file in ms access, how to backup microsoft access database,
Access backup database automatically,
Ms access database backup VBA,
#mstutorial
#microsoftaccesstutorial
#microsoftaccess

[@geniusaeqcomputers5792]

Thank you for your good work, your video tutorials have helped me to improve in my database builder in access VBS coding.

[@EdcelleJohnGulfan]

I'm so glad it helps.

[@EdcelleJohnGulfan]

Thanks for watching my videos.

[@Initial_Gain]

Thank you, I'll use this code to create a Backup button in my database. You're very talented and young!
🇲🇹

[@EdcelleJohnGulfan]

Thanks for watching man. It's highly appreciated.

[@stewartwilkinsonsnr]

Edcelle, Wow so pleased I found your channel. Since I retired (2009) and during Lockdown in UK I have been learning Access by watching UA-cam. The one thing I have been trying to do is save the file automatically using a button. So my sincere Thanks for you well presented video. Kindest Regards Stewart 👍👏

[@EdcelleJohnGulfan]

Thank you so much for watching my videos Stewart. I'm glad that my video helps you.
Once again thank you so much.

[@stewartwilkinsonsnr]

@@EdcelleJohnGulfan Followed your coding and so pleased as it works just great 👍

[@EdcelleJohnGulfan]

Thanks it helps.

[@LucyEssex]

Just what i was looking for - thank you

[@EdcelleJohnGulfan]

Thanks also for watching.

[@emilybaas]

this video was exactly what I needed thank you SO much.
Any chance you can make another video on how to create a macro that opens this form to “click” this button?
I’m not familiar with the coding side of access. So when I create a macro attempting to do this (not using VBA code) I think it’s causing an issue and it needs a macro created using VBA code

[@ModawanaTech]

Excellent 👍🎉

[@rzgartech]

Thanks for you, i subscribed and liked

[@EdcelleJohnGulfan]

Thanks for it

[@Shadow.Dragon]

Excellent video! I presume that the "A" integer returns the "state" of the copy (i.e. successful or not)? Can you then use this "state" to give the user feedback?

[@deozaxsingerandgaming]

Good.thank.

[@EdcelleJohnGulfan]

Thank you too.

[@Waberduggi]

Great, Thank you

[@EdcelleJohnGulfan]

Thanks for watching Ruedi.

[@amitpawaronline]

Hi, thanks for this video tutorial. Is it possible to keep only last five days backup, I mean is there any way to auto delete everyday backup after 5th day ?

[@EdcelleJohnGulfan]

Yes. Kill function

[@altdel126]

Great work!!
could please make this same to backup Database only, I mean not with forms

[@popongmark1158]

Thanks for the video... Gaubra ko og employee data base sa among lgu, hope u can help po.. thanks

[@EdcelleJohnGulfan]

Pwede.

[@daveyks1]

This is great....can you do one that does the same thing for a SQL back end?

[@EdcelleJohnGulfan]

I'll try that.

[@syedabbas201]

Nice help full video.
But How to make Timing auto Backup. For exp I set 3:00 pm automatic back up on 3:00 ??

[@EdcelleJohnGulfan]

You can use ON TIMER EVENT.
But make sure the database is ACTIVE.

[@EdcelleJohnGulfan]

Thanks for the question

[@syedabbas201]

Thanks for Reply. Have you made any Video on timing Backup??

[@eduardogulfan4875]

Not yet but I'm doing that in my projects.

[@renatovincis3455]

Ciao Edcell, si può eseguire il backup anche se ci sono degli utenti collegati?

[@EdcelleJohnGulfan]

Yes Sir. No issue.

[@Azheenyasin]

Thanks bro,
But when you quit app there will be one copy of the file how can i change the format of the copied file by time and date so each time i close the app i want it to copy a backup file of that time.

[@EdcelleJohnGulfan]

Hi. Sorry for late reply.
For the Target. You can change the code into like this...
TARGET: Target & format (Now(), " hh-mm-mmm-yyyy) & ".accdb

[@saeedbaryal8723]

I a week or almost two weeks ago asked a question, but I didnt get the answer.
The question was, Filter by option group in navigation control doesnt work. Hope you will give me the answer.

[@EdcelleJohnGulfan]

Sorry for that. Honestly, I can't read all the comments. Thanks for telling me now.
Can you just tell me your concern here about option group?

[@budimansudjatmiko8425]

Broo...... is it work on split database ?

[@EdcelleJohnGulfan]

Yes, but instead the path of front end, you should type the path of backend so that the back end will be copied.

[@budimansudjatmiko8425]

@@EdcelleJohnGulfan OK.... I'll try that.... thanks for your answer......

[@johnkennethdeguzman2667]

Sir Edcelle Good day po. Bakit po pag nag lagay ako ng page 3 sa TAB FORM hindi nakikita sa Form View ang laman ng page 3. Pero sa Design View naman nakikita sya. Ano po kaya ang mali ko dun. Pa sagot naman po. Maraming salamat

[@EdcelleJohnGulfan]

Hi sorry for late reply. ngayon ko lang nabasa.

[@EdcelleJohnGulfan]

baka po sa format. yung VISIBLE ay naka NO.

[@kierikitiw]

Paano po kung ung path eh mag oopen kung saan mo sya ibaback up. Possible po ba un

[@EdcelleJohnGulfan]

E.type mo lang sa path ang location na gusto mo doon e.save.

[@EdcelleJohnGulfan]

Sample sa Drive C.
Path = "C:\Back Up Database"

[@RHUDelfinAlbano]

sir paano kung ilipat ung back up file sa ibang location

[@EdcelleJohnGulfan]

Change the PATH Sir.
Sample ilipat sa Drive C.
Path = "C:\Database Back Up"

[@EdcelleJohnGulfan]

Make sure that folder name is exist in drive C.

[@johnkennethdeguzman2667]

Sino po kaya makakasagot sa tanong ko. Pasuyo naman po. PLs