Click here to Skip to main content
13,148,103 members (71,097 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Hi every one, I need help with devising logic for archiving data. Currently I am storing data in an access database. The customer requires the data to be archived after a month. The data is being feteched by a c# application and then stored into access
Any suggestions would be great
Posted 23-Feb-13 5:05am
Updated 23-Feb-13 5:07am
braop 24-Feb-13 10:47am
Hope this helps:

1. know when you want to archive your data. say per month
2). Date will be so virtual in archiving, inserting and retrieving data
3). Create a form where data of past months can be accessed from, that is if ur data is being archive on monthly basis

Assuming u want to view that from ur access database select where month = this makes it impossible to view data of past months thus data from past months can only be accessed via the archive form.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Select * into month from History

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170924.1 | Last Updated 8 Mar 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100