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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto Back up Tables from access

Status
Not open for further replies.

JBParfives

Technical User
Joined
Mar 25, 2009
Messages
2
Location
US
I want to back up/archive a table every 3 months. I want the code to do this on its own. The query will combine data from two tables into 1 table. The reason! We have a database that updates 24 hours a day and in three months generated 36000 records that contain up to 20 columns of data. We do not want to delete the old data. By archiving quartely it should let us look at current trend in our production data.
 
1) You need a table to store the Date of Last Archive/ Archiving Date.
2) A Macro/code to check the difference between date of last Archive and date today.(In the startup form or AutoExec Macro)
3) Notify the user(If necessary)
4) Run the Archiving Query
5) Run Delete Query from the base table(s)

Zameer Abdulla
 
The table and the query are not my problems. My problem is the VBA code to execute the function. I have almost zero code writing experience.
 
If you have difficulty with the code, you can use the wizards or macros. All the steps supplied by ZmrAbdulla can be easily selected from the macro design screen. It is also possible to save macros as code.

Please check out the FAQ especially point 10.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top