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
ruclips.net/user/EdcelleJohnGulf...
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

[@ModawanTech]

Excellent 👍🎉

[@cosmicfugue1226]

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.

[@rzgartech]

Thanks for you, i subscribed and liked

[@EdcelleJohnGulfan]

Thanks for it

[@Waberduggi]

Great, Thank you

[@EdcelleJohnGulfan]

Thanks for watching Ruedi.

[@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?

[@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

[@deozaxsingerandgaming]

Good.thank.

[@EdcelleJohnGulfan]

Thank you too.

[@altdel126]

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

[@daveyks1]

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

[@syedabbas201]

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

[@eduardogulfan4875]

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

[@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

[@renatovincis3455]

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

[@EdcelleJohnGulfan]

Yes Sir. No issue.

[@popongmark1158]

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

[@EdcelleJohnGulfan]

Pwede.

[@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

[@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?

[@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"

[@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]

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

[@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.