How to Create Auto Backup File

[@danielwong5182]

Thank you for making excellent MS Access tutorials. I added this backup code to my database, and it works great!!! Would you be able to demonstrate how to write the code to backup the database to a USB storage device and also how to resolve an error when there is no USB storage device installed, prompting the user to install a USB storage device? Again, thank you for all your MS Access video tutorials, you are an excellent instructor!!

[@paulskelton8799]

Well explained and effective. Access will be around for a while yet I think! Many thanks for sharing your knowledge

[@pathtolightbd]

Another great tutorial as always! Could you pls consider creating a video tutorial on kicking all users out automatically before the "Module" is executed to ensure that the Database is not in use by anyone when the backup is created.

[@Asterix34518]

Thanks very much. That was a very good and detailed explanation on how to back up a file in Acces.

[@Andika-vt4wh]

Bagus sekali Bro saya sudah menerapkannya. Salam kenal saya dari Indonesia lanjutkan videonya Saya menunggu

[@luismerida5210]

I think yuo are a good teache!!!!. See you another time, thank you very much.

[@pathtolightbd]

Would greatly appreciate if you could also consider creating a video on compacting the backend database automatically and kicking all users out before the Compact&Repair Module runs to avoid possible data corruption in the process.

[@practice-me]

May I have a question, If access file still used, we can do these backup function. ?

[@nigelkey8157]

Great tutorial - thank you. The laccdb file stays open any way to resolve this ?

[@chrisj279]

I've got this code done exactly like in the video, but am getting a "Compile Error: Expected variable or procedure, not module" every time i try to run it. Its like Access can't find it, even though it appears as a module in my database . I tried using the "Runcode" function under the macro builder, which someone suggested online and it says "The expression you entered has a function name that Microsoft Access can't find. Any ideas?

[@igormalinkov4128]

Thanks a lot.

[@medoAlshehri1990]

Thank you so much that was really helpful

[@heangkimhay1753]

Thank you so much for very useful code for current DB back up. It’s very appreciated if you could share the code for others DB (for example back up the link table of other DB) back up. Again thank you so much for this video.

[@jamesrequilme]

Hi, how to change the source as backend database to backup. At the video, Source=CurretnDb.Name, however I want to backup only the backend file. Many thanks in advance!

[@austin72406]

check out my new video here: kzbin.info/www/bejne/eXjFnGSEmp6NoNk

[@rajuthivagar6042]

Hi can you share how to create stock in and stock out in inventory system

[@Thanogr1]

You should create a course at UDEMY

[@kefahnaman8070]

There were some problems with me .. when I applied the vba code ..yellow line at: a=objFSO.copyfile (source, target ,true) What is the problem ? I use Microsoft office 2016 and Win 10

[@jakobking123]

I had the same problem, it occurs because you cant copy a file that is currently running. When you implement a function in the "On Load" Event, your Databse was already executed and is running, so it wont let you copy this opened file. Maybe check that first and try to copy any other file, if this works this is the same error I get.

[@homesafe8632]

That's very useful 👍

[@ahsansolangi48]

I face error 429 ActiveX component can not create object please help.

[@bdhis24]

bdhis24