自动备份mdb访问文件 [英] Automatic Backup of a mdb Access file

问题描述

大家好！

在我的工作场所，有许多用户共享的数据库（不是我在其他帖子中提到的那个，而是一个新用户！）。它是一个没有前端或后端副本的单个mdb。只是普通的原始mdb文件，位于网络中所选用户共享的文件夹中。

目前的情况如下：其他用户对我的访问及其世界的想法甚至更少;他们只想要一个可以输入数据的表格。到目前为止，这并非罕见的情况。尽管如此，由于数据库文件正在全速运行（即，由所有用户访问），因此Access几天内在同一文件夹中自动生成了两个或三个备份副本。我不知道是谁对此负责，也就是说，当发生这种情况时谁在使用数据库，我甚至不知道这是否是由其中两个用户造成的，例如。我现在只能说，数据库是一个Access 97文件，我们所有人，除了在他的计算机上安装了Access 2002的单个用户，都使用Access 97打开数据库。

我能想到的唯一风险就是信息丢失，因为我了解Access在检测到可能威胁数据完整性的问题时会自动生成备份副本。是对的吗？什么可能导致备份副本的出现？我们的数据现在是否安全？


来自巴塞罗那的最佳问候

Hello everyone!

At my workplace, there is a database shared by many users (not the one I have been mentioning in other posts, but a new one!!). It is a single mdb with no front or back-end copies or whatever. Just the plain and original mdb file, in a folder shared by the selected users in a network.
The current situation is as follows: the rest of the users have even less idea than me of Access and its world; they just want a form displayed in which the data can be typed. Up to this point, this is not an uncommon situation. Nevertheless, since the database file is working at full throttle (that is, accessed by all users), two or three backup copies have been automatically generated by Access itself in the same folder in few days. I don''t know who is responsible for this, that is, who was working with the database when this happened and I don''t even know if this was caused by a single user of two of them, for example. All I can say, right now, is that the database is an Access 97 file and that all of us, except from a single user who has the Access 2002 installed in his computer, open the database with Access 97.
The only risk I can think of in here is the loss of information because I understand that Access makes a backup copy automatically when it detects a problem that may threaten data integrity. Is that right? What could cause the appearance of that backup copies? Is our data safe right now?

Best regards from Barcelona

推荐答案

我很久没有使用过这些版本，但我知道每当Access 2003/2007发生不可恢复的崩溃时，它都会在同一个文件夹中创建一个备份副本。这并不意味着您的数据已损坏，但肯定会导致这种情况发生。事实上你没有拆分这个数据库，并允许很多用户同时访问它，这有点吓人！您确实需要拆分此数据库，并将前端副本分发给所有用户。直到你这样做，并为你的后端文件设置某种备份例程，不，你的数据是不安全的。


如果你需要任何帮助，那么'关于如何拆分数据库以及分发前端文件的大量帖子。请告诉我，我可以提供一些指向我在此发布的主题的链接。

I havent used those versions in a long time, but I know that whenever Access 2003/2007 does an unrecoverable crash, it will create a backup copy in the same folder. This doesnt mean your data is corrupted, but it sure could cause that to happen. The fact that you havent split this database, and allow ''many'' users simultaneous access to it, is kind of scary! You really need to split this db up, and distribute front end copies to all the users. Until you do this, and set up some sort of backup routine to your back-end file, no, your data isn''t safe.

If you need any help, there''s plenty of posts on how to split the db, and to distribute the front end files. Just let me know and I can provide a few links to topics I''ve posted on this.

Megalog：


如果你能提供帮助我有这个问题，提供你提到的链接，我将不胜感激！


非常感谢您提前!!


祝你好运

Megalog:

If you could help me with this issue, providing the links you mention, it would be much appreciated!!

Thank you very much in advance!!

Best regards

当然可以！

首先，这里是拆分数据库的方法。

前端/后端（FE / BE）操作方法


这是我之前发布的关于如何发布的帖子管理更新和分发您的FE / BE。

MDE文件


彻底阅读，试一试。

在执行任何操作之前，请确保先备份数据库。

Sure!

First, here''s the How-To for splitting the db.

Front-End / Back-End (FE/BE) How-To

And here''s a posting I did before about how to manage updating and distributing your FE/BE.

MDE Files

Read both thoroughly, and give it a try.
Just make sure you back-up your database first before doing any of this.

这篇关于自动备份mdb访问文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！