Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to back up database(access) based on selected periodic

Status
Not open for further replies.

sn00pies

Programmer
Jun 30, 2006
12
MY
i am using VB to backup my database(access), as my VB form has 2 combo boxes(month and year) to allow user to select which month to back up thier database... once the user select periodically, it will back up the
database.mdb into particular folder which i am using FSO to locate.

What solution i need to find out is i want to back up several database accordingly to the month the user selects... i.e from January to april, it
will grab 3 files for each month which is january, february and March. And each will be renamed as 1.mdb, 2.mdb and 3.mdb . Please eliminate the month of
April because i still want the record remains once the user select till that month.


Roughly navigate me pls...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top