Backup database

[sdawson]

Has anyone got a bit of code to run Tools, Database Utilities, Back Up Database on exiting the database.
Probably involes the old fashioned Keys command which I've forgotten how to use.

Ta

 

[MSAccessRookie]

Has anyone got a bit of code to run Tools, Database Utilities, Back Up Database on exiting the database.
Probably involes the old fashioned Keys command which I've forgotten how to use.

Ta

The Forum Archive contained several discussions on the subject in the recent past. Below are Four such entries. You can also search the Forum Archive for Additional entries.

http://www.access-programmers.co.uk/forums/showthread.php?t=164083&highlight=backup

http://www.access-programmers.co.uk/forums/showthread.php?t=163848&highlight=backup

http://www.access-programmers.co.uk/forums/showthread.php?t=163787&highlight=backup

http://www.access-programmers.co.uk/forums/showthread.php?t=161699&highlight=backup

 

[sdawson]

Seen these.
I want the user to specify the destination that is why I posted the question the way I did!

 

[MSAccessRookie]

Seen these.
I want the user to specify the destination that is why I posted the question the way I did!

That particular requirement should not be as important as where and how to backup the database. After all, to provide input, the user can:

• Answer an Input Message Box
• Enter the data in a field of a form
• Select a Destination from a list

After the user has responded, Access can perform the Backup according to the user request.

Note: Other user input methods that are not listed may also be available.

 

[Mike375]

This thread

http://www.access-programmers.co.uk/forums/showthread.php?p=788463#post788463

has the link to the zipping that was mentioned in a couple of the threads that MSAccessRookie posted. Go about 5 postings down to the post by Shadow.

This works great. You can enter the path you want or you can store it or you could make so it gets the path dynamically.

What is great about using this zipping is a zip of the DB can be made while the DB is open and then you have code in your DB copy and date/time stamp the zip file to your chosend folder (s). Like some other DBs that have been made like Leban's Report into PDF file, Browne's ListFiles etc. the best results are to bookend what they have made with your own stuff.

 

[shadow9449]

This thread

http://www.access-programmers.co.uk/forums/showthread.php?p=788463#post788463

has the link to the zipping that was mentioned in a couple of the threads that MSAccessRookie posted. Go about 5 postings down to the post by Shadow.

This works great. You can enter the path you want or you can store it or you could make so it gets the path dynamically.

I was going to post that! My solution stores the path in a table and defaults to the stored path or lets the user find a new one via a browser.

One thing I haven't done is automated backup where the user can type in a time of day where the program would execute the backup. I'm not sure how this would work on a network with a few dozen users.

SHADOW