Auto Back up Tables from access

[JBParfives]

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.

 

[ZmrAbdulla]

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

 

[JBParfives]

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.

 

[Remou]

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

http://www.tek-tips.com/faqs.cfm?fid=2886,

especially point 10.

http://lessthandot.com