I'm looking for straight-forward VB6 code to automatically and behind the scenes backup a number of password-protected Access 2000 databases.
Attached are 3 database examples, [login to view URL], [login to view URL], and C.mdb. (password is a123 for A, b123 for B, and C is not password protected) located in a folder called DBs.
There should be one form that will show the paths & names of A,B, and C, and allow the user to pick (and make a new folder if desired) one location where the backups will be saved. Being able to chose a location over a network is critical.
This form needs to allow the user to determine how frequently to backup the databases in hourly increments (e.g., every 1 hour, or 2 hours, or 3 hours, etc.) with a default value of every 1 hour.
Users must also be allowed to pick how many backups they want to save, from 1 to 6, with a default value of 3.
The way this should work is when the backup first starts, [login to view URL] will be backed up as 0HrAgo_A.mdb. The next hour, when the back up occurs again, I want [login to view URL] to be RENAMED [login to view URL] and then the current [login to view URL] will be backed up to replace 0HrAgo_A.mdb. In this way, if the user wants to save the last 3 backups, there will be 3 backup files for A.mdb. These will be [login to view URL] which will contain the most recent information, [login to view URL] which is the database from an hour ago, and [login to view URL] which is the database copy from 2 hours ago. The same setup will occur for [login to view URL] and [login to view URL]
I also want a daily backup made in this manner, so that [login to view URL] will have a backup called [login to view URL] (i.e., [login to view URL]). The user must be able to pick how many days worth of backups they want to save from 1 day to 7 days, with a default of 3.
The user should be able to manually backup all databases, or turn on (or off) automatic backup - which could be done by opening a hidden form that runs in the background.
The code must not use any ocx's or unusal dlls. See more details in zip...
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Complete ownership and distribution copyrights to all work purchased.
## Platform
win