Backup Database within access

[Slyke]

Yes, the "Back Up Database" menu does that, it closes the database, displays a dialog box asking where to make the backup to, with a filename, then reopens the database after the process has been completed. All in access.

The menu is File>Back Up Database.

The code i posted in the first post displays this dialog box when the user clicks the command button. What i'm asking is how to change the default filename in the dialog box before it opens up.

The reason that the person wanted this is because it's tedious changing numbers (dates) in the filename since the default filename is today's date, when actually, we want the database date (in the filename) to be another time.

The data that will be placed in the backup's filename is from some data in the database.

So unless the database can have some code that closes itself, execute some code to copy the closed database, and then reopen itself externally back to it's original state, this is really the only way to do it. Also using this method, most of that is already done (except the file name!!!).

See the attached images:

Backup Dialog:


Where to find it in the menu system: