数据文件损坏的原因？ [英] Cause Of Data File Corruption?

问题描述

我有一个Access 2003数据文件，现在已经在

周内损坏了两次。数据库非常简单，只有一个主数据表和几个查找表。查找表通过

关系链接到主表。每个用户都有自己的前端副本，

链接回服务器上的数据文件。


损坏的数据文件修复正常，但在两种情况下2

关系在关系窗口中消失了。当

恢复时，一切恢复正常。没有数据被破坏。


这可能很难说，但这种腐败可能是由于通常有故障的网卡或连接导致的b $ b b还有其他

的原因吗？我能做些什么来追查实际的

原因？

I have an Access 2003 data file that has now corrupted twice in a
week. The database is extremely simple with one main data table and a
few lookup tables. The lookup tables are linked to the main table via
relationships. Each user has their own copy of the frontend which
links back to the data file on the server.

The corrupted data file repairs OK but on both occasions 2
relationships have disappeared in the Relationships Window. When
these are reinstated all is back to normal. No data is corrupted.

It is probably hard to tell, but can this sort of corruption be caused
by the usual faulty network card or connection or can there be other
causes? Is there anything that I can do to track down the actual
cause?

推荐答案

问题通常源于在网络上拥有共享的mdb。如果

多个用户打开了应用程序而其他人在其上执行了一个紧凑/修复的问题 - 这就是出现问题的地方。这是一个原因（几个）为什么使用基于文件的RDBMS（如Access）作为基于服务器的RDBMS（如sql server）之类的网络的共享系统）

会导致问题。

Rich


***通过Developersdex发送 http://www.developersdex.com ***

The problem usually stems from having a shared mdb on a network. If
more than one user has the application open and someone else performs a
compact/repair on it - that is where the problem arises. This is a
reason (of several) why using a File based RDBMS (like Access) as a
shared system over a network like a Server based RDBMS (like sql server)
will result in problems.
Rich

*** Sent via Developersdex http://www.developersdex.com ***

Rich P < rp ***** @ aol.comwrote in

news：12 ************* @ news.newsfeeds.com:

Rich P <rp*****@aol.comwrote in
news:12*************@news.newsfeeds.com:

问题通常源于在网络上拥有共享mdb。

如果有多个用户打开了应用程序并且其他人

对它执行紧凑/修复 - 这就是出现问题的原因。这是（多个）为什么使用基于文件的
RDBMS（如Access）作为网络上的共享系统的原因，例如基于服务器的RDBMS（如sql server） ）会导致问题。


Rich


***通过Developersdex发送 http://www.developersdex.com ***

The problem usually stems from having a shared mdb on a network.
If more than one user has the application open and someone else
performs a compact/repair on it - that is where the problem
arises. This is a reason (of several) why using a File based
RDBMS (like Access) as a shared system over a network like a
Server based RDBMS (like sql server) will result in problems.
Rich

*** Sent via Developersdex http://www.developersdex.com ***

Rich，


你正在通过你的帽子说话。首先，OP表示他的每个用户都拥有自己的前端副本。只要.ldb

表示其他用户打开.mdb，就不会在共享后端进行紧凑和

修复。所以'不是OP'的

问题。


-

Bob Quintal


PA是我改变了我的电子邮件地址。

**发自 http://www.teranews.com **

Rich,

you are talking through your hat. Firstly, the OP states that his
users each have their own copy of the front end. A compact and
repair will not happen on a shared back end as long as the .ldb
indicates other users have the .mdb open. So that''s not the OP''s
problem either.

--
Bob Quintal

PA is y I''ve altered my email address.
** Posted from http://www.teranews.com **

对不起，Rich，你错了。当其他人打开应用程序时，没有人可以在后端db上执行和压缩/修复
。它没有腐败，只是

无法紧凑。


OP表示每个用户都有自己的前端，所以如果他们是/>
压缩/修复他们的前端，没有人打开那个db文件。它没有腐败，它按照指示压缩。


在网络上拥有共享数据库并不会导致损坏。它没有正确设置

（许多共享相同的前端或甚至没有拆分

共享数据库），在写入磁盘时切断电源，故障网络，无线

网络连接和文件服务器的机会锁定

导致损坏。


Chris

Microsoft MVP

Rich P写道：

Sorry, Rich, you''re mistaken. When others have the app open, no one can
perform and compact/repair on the back end db. It doesn''t corrupt, it just
fails to compact.

The OP stated that each user has their own front end, so if they
compact/repair their front end, no one else has that db file open. It
doesn''t corrupt, it compacts as directed.

Having a shared db on a network doesn''t cause corruption. It''s not setting
it up properly (many sharing the same front end or not even splitting the
shared db), cutting the power while writing to disk, faulty network, wireless
connections on the network and opportunistic locks from the file server that
cause corruption.

Chris
Microsoft MVP
Rich P wrote:

>问题通常源于在网络上拥有共享mdb。如果多个用户打开了应用程序而其他人对其执行了紧凑/修复 - 这就是出现问题的地方。这是（有几个）为什么使用基于文件的RDBMS（如Access）作为基于服务器的RDBMS（如sql server）之类的网络共享系统的原因
将导致问题。

Rich

>The problem usually stems from having a shared mdb on a network. If
more than one user has the application open and someone else performs a
compact/repair on it - that is where the problem arises. This is a
reason (of several) why using a File based RDBMS (like Access) as a
shared system over a network like a Server based RDBMS (like sql server)
will result in problems.

Rich

-

通过AccessMonster.com发布消息
http://www.accessmonster.com/Uwe /For...ccess/200808/1

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1

这篇关于数据文件损坏的原因？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！