Back Up Ms Access Automatically

[@mr.somchaivaroonchotikul5117]

Dear friend, your programming is very useful for me.

[@Hubris786]

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

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

[@ladyouch18]

Thank you so much!

[@esam2017]

Thank you

[@ssemaga]

Most welcome

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

[@shahdtae439]

thank you very much

[@ssemaga]

Most welcome.

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

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

[@sindusri-2463]

❤️❤️❤️

[@ssemaga]

Thanks