Issuing a DOS command when you close Access database

[Roncc]

I have an Access database that I would like to have automatically backed up when I close the program. I have a "Quit Application" button on my MainMenuFrm that runs the code:


DoCmd.Quit acPrompt

but I would like the program to initiate a backup command following the closing. I can program a dos command like xcopy *.* h:\dailybackup /y

and this is the type of code I want to run automatically when I close the program.

Any ideas on how I can tie the two together?

Thanks for the help.

[CJ_London]

what are you trying to back up? the data or the forms/reports etc? The data should be in a separate backend, so you can just use vba to copy it to another location (the vba filecopy function) - since you are on the 'exit route' you presumably are not updating tables at that point. Front ends should never change so don't need backing up - except when developing and then there is no guarantee the form you want to run the code will be open. If your db is multi user, backing up on exit is generally a bad idea - if a backup is taken whilst another user is making changes can result in an incomplete transaction.

[Roncc]

The program is not on a server. It is a stand alone. I want to backup the entire database to a thumbdrive.

[CJ_London]

I didn't ask about a server. However backup up to a thumb drive has many potential problems - not connected, connection interrupted, drive full to name the obvious ones. It is not something I would want to get involved with. Suggest look at using the vba Shell command to execute a DOS command or google something like 'vba to execute a DOS command', I can see there are plenty of links on the subject. Good luck with your project

[CJ_London]

I didn't ask about a server. However backup up to a thumb drive has many potential problems - not connected, connection interrupted, drive full to name the obvious ones. It is not something I would want to get involved with. Suggest look at using the vba Shell command to execute a DOS command or google something like 'vba to execute a DOS command', I can see there are plenty of links on the subject. Good luck with your project

there is also a link at the bottom of this thread from someone who has the same basic requirement

https://www.accessforums.net/showthread.php?t=51228