I've a simple question, i wonna make a program using access database to store the entered data and making some calculations on it to get the total income per day and per week, how could i backup the old data and save it in a separate database at the runtime to emptying the original database and accept a new data, i wonna make this kind of mechanism to avoid filling out of original database and to keep it accept a new data forever, so is this possible to achieved??
if not what's the suggested solution to achieve this??
MxDev -2 Junior Poster
stultuske 1,116 Posting Maven Featured Poster
I don't see the point of doing so. but yes, that is possible.
but then again.. do you mean you want to create a table or such for every seperate week?
I do hope you have some hard disk space to spare :/
dickersonka 104 Veteran Poster
agree with stultuske, quite a cumbersome task
not sure how your db is laid out, but typically what you would do insert a new record with a timestamp and only pull from the latest timestamp's results
also you could set a boolean value for the row, to show if its inactive or active, and only pull rows where active =1, and still maintain the old rows
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.