将Access 2003归档数据库链接到活动数据库 [英] Link Access 2003 archive database to active database

问题描述

我们需要归档一个数据库，清空表并继续使用相同的数据库，在表中产生一些差异，但我需要设置一个允许活动数据库访问的开关或子表单或查询存档数据库。 不只是
a表或两个，而是归档数据库。

We need to archive one database, empty the tables and continue with the same database, making some differences in the tables, but i need to put a switch or subform or query that will allow the active database to access the archived database.  Not just a table or two, but the archived database.

谢谢

推荐答案

恕我直言，正确答案是不要将数据存档到不同的数据库/一组不同的表。 这样做只会破坏数据集，并在数据库中造成效率低下。

IMHO, the correct answer is don't archive data to a different datadase/a different set of Tables.  Doing so only fragments your dataset and creates inefficiencies in your database.

即使您使用"归档"也是如此。如你的帖子所述，你应该把它视为具有安全边际的删除，以防你再次需要数据作为
一次性关闭情况，当然不需要 "存档"根据所描述的用户界面设计定期数据。

Even if you use "archiving" as described in your post, you should think of it as deletion with a safety margin in case you need the data again as a once-off situation, certainly not needing the "archived" data regularly as per the user interface design described.

如果你想呈现不同的数据集"当前"数据。和"已存档"，添加2个字段：

If you want to present different sets of data "current" and "archived", add 2 Fields:

已存档  布尔值默认值否/错误

Archived   Boolean Default No/False

ArchivedDateTime   DateTime

ArchivedDateTime   DateTime

（实际上，1个字段就足够了，ArchivedDateTime会为数据库的信息内容添加更多内容）。 

(in fact, 1 Field is enough and ArchivedDateTime add more to the info content of the database). 

当你想要"存档"时数据，设置字段的值并重新设计您的FUI /表单以过滤打开的记录为"当前"字段。仅在用户稍后使用上述字段时所要求的。

When you want to "archive" data, set values for the Field(s) and re-design your FUI/Form to filter the records on open to "current" only or as required by the user later using the above Field(s).

这篇关于将Access 2003归档数据库链接到活动数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！