Click here to Skip to main content
15,916,215 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello World,

I have made an app that connects to Device VIA Modbus and collects data, stores it in a database and then generates a report based on the database. The user will be generating 200-500 reports / database records a day.

I am using an
Access Database(.accdb)
and as i know it has a limitation of
2GB and a limit of 32 768 records
. The customer requires to use this almost everyday for a long time and i cannot afford lack of space.

How do you create a database archiving system that archive's the data after 30 days.
And how do you delete the crystal reports records that were archived.

Travis

P.S This is URGENT Pls, your help is greatly appreciated
Posted

1 solution

As per Customer requirements i think you have to use Sql DataBase as a Backend insted of MS-Access DataBase.
 
Share this answer
 
Comments
Travis Singh 9-Dec-11 19:58pm    
Thanks, but is there a way to do it in Access. I found a method in Microsoft's website to do this in access by adding an append query. My question is that if i were to place it into my project will the archiving query work or how to call it

(I am using database for the first time)

Travis

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900