Creating A Database Archive In VB?

Question

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 9-Dec-11 5:21am

Travis Singh

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

**Manoj K Bhoir** · Answer 1 · 2011-12-09T05:45:00

Solution 1

As per Customer requirements i think you have to use Sql DataBase as a Backend insted of MS-Access DataBase.

Posted 9-Dec-11 5:45am

Manoj K Bhoir

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