在VB中创建数据库存档? [英] Creating A Database Archive In VB?

问题描述

Hello World，

我制作了一个连接到Device VIA Modbus并收集数据，将其存储在数据库中，然后基于该数据库生成报告的应用程序.用户每天将生成200-500个报告/数据库记录.

我正在使用

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

.客户几乎每天都需要长时间使用它，而我又无法承受空间不足的情况.

您如何创建一个数据库存档系统，该系统可以在30天后对数据进行存档.
以及如何删除已存档的Crystal Reports记录.

特拉维斯

PS这是 URGENT ，请您帮忙非常好赞赏

. 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

推荐答案

根据客户要求，我认为您有使用Sql数据库作为MS-Access数据库的后端.

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

这篇关于在VB中创建数据库存档?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！