网络计算机突然无法访问数据库？ [英] Network Computers Suddenly Can't Access Database?

问题描述

我们用这个数据库快乐地连续工作了6年来记录进入我们办公室的所有客户支票，包括信息<关于支票的用途是什么。


突然，网络电脑无法访问数据库。


消息是...


Microsoft Jet数据库引擎无法打开文件

C：\ SomeFolder \SomeSubfolder \Somefile.mdb。它已被其他用户专门打开

，或者您需要获得查看其数据的权限。


据我所知，没有任何改变权限，我做了

肯定没有其他人打开文件。我唯一可以想到的是

可能影响了该文件的原因是我周五可能压缩了数据库

并且问题在下周二浮出水面。网络上的所有计算机都可以看到对方，并且可以很好地共享数据。

数据库包含许多表，查询，表单和报告。它是
重3.5 MB。


有些网络计算机在打开这个

文件时遇到问题子文件夹，而其他计算机无法打开子文件夹中的任何

文件。在每种情况下，消息都是相同的。文件所在的

网络计算机可以打开所有文件。所有

网络计算机可以访问文件夹中其他子文件夹中的所有其他文件（Word，Excel）。


事实上，子文件夹被命名为Access，Execl，Word等。


1.失败的家庭补救措施＃1。我重启了所有电脑。没有变化。

2.失败的家庭补救措施＃2。我将所有文件移动到一个新的子文件夹中。

这个工作了一天。然后，消息再次出现在

之后。

3.未经测试的Home Remedy＃3。我将所有文件移动到一个新的子文件夹

再次，但我也删除了一些记录，认为可能数据库是

大到14,000条记录。我将记录数量减少到不足12,000美元。


可能是什么问题？

可能是什么解决方案？


谢谢，

MHenry

Hi,

We were going merrily along for 6 years using this database to record
all client checks that came into our office, including information
about what the checks were for.

Suddenly, network computers cannot access the database.

The message is...

"The Microsoft Jet database engine cannot open the file
C:\SomeFolder\SomeSubfolder\Somefile.mdb. It is already opened
exclusively by another user, or you need permission to view its data."

So far as I know, nothing has changed with the permissions, and I made
sure no one else had the file open. The only thing I can think of that
might have affected the file is that I may have compacted the database
on Friday and the problem surfaced the next Tuesday. All the computers
on the network can see each other and share data just fine. The
database contains numerous tables, queries, forms, and reports. It
weighs in at 3.5 MB.

Some of the network computers have a problem opening only this one
file in the subfolder, while other computers can''t open any of the
files in the subfolder. In each case, the message is the same. The
network computer on which the files reside can open all the files. All
the network computers can access all the other files (Word, Excel) in
other subfolders within the Folder.

In fact, the subfolders are named, Access, Execl, Word, etc.

1. Failed Home Remedy #1. I rebooted all the computers. No change.
2. Failed Home Remedy #2. I moved all the files into a new subfolder.
This worked for one day. Then, the message appeared again the
following day.
3. Untested Home Remedy #3. I moved all the files into a new subfolder
again, but I also deleted some records, thinking maybe the database is
getting to large with 14,000 records. I reduced the number of records
to less than 12,000.

What could be the problem?
What could be the solution?

Thanks,
MHenry

推荐答案

On 2004年2月18日星期三17:18:23 -0800，MHenry写道：

On Wed, 18 Feb 2004 17:18:23 -0800, MHenry wrote:

我们用这个数据库快乐地走了6年记录
进入我们办公室的所有客户支票，包括有关支票的信息。

突然间，网络计算机无法访问数据库。

Microsoft Jet数据库引擎无法打开文件
C：\ SomeFolder \SomeSubfolder \Somefile.mdb。它已经由其他用户专门打开，或者您需要获得查看其数据的权限。

据我所知，权限没有任何变化，我做了数据库包含许多表，查询，表单和报告。它的重量为3.5 MB。

有些网络计算机在子文件夹中只打开这个文件时出现问题，而其他计算机无法打开任何文件子文件夹中的
文件。在每种情况下，消息都是相同的。文件所在的网络计算机可以打开所有文件。所有网络计算机都可以访问文件夹中其他子文件夹中的所有其他文件（Word，Excel）。

实际上，子文件夹名为Access，Execl， Word等。

1.失败的家庭补救措施＃1。我重启了所有电脑。没有变化。
2.失败的家庭补救措施＃2。我将所有文件移动到一个新的子文件夹中。
这个工作了一天。然后，消息再次出现在
第二天。
3.未经测试的家庭补救措施＃3。我再次将所有文件移动到一个新的子文件夹中，但我也删除了一些记录，认为数据库可能会有14,000条记录。我将记录数量减少到不到12,000个。

可能是什么问题？
可能是什么解决方案？

谢谢，
MHenry

Hi,

We were going merrily along for 6 years using this database to record
all client checks that came into our office, including information
about what the checks were for.

Suddenly, network computers cannot access the database.

The message is...

"The Microsoft Jet database engine cannot open the file
C:\SomeFolder\SomeSubfolder\Somefile.mdb. It is already opened
exclusively by another user, or you need permission to view its data."

So far as I know, nothing has changed with the permissions, and I made
sure no one else had the file open. The only thing I can think of that
might have affected the file is that I may have compacted the database
on Friday and the problem surfaced the next Tuesday. All the computers
on the network can see each other and share data just fine. The
database contains numerous tables, queries, forms, and reports. It
weighs in at 3.5 MB.

Some of the network computers have a problem opening only this one
file in the subfolder, while other computers can''t open any of the
files in the subfolder. In each case, the message is the same. The
network computer on which the files reside can open all the files. All
the network computers can access all the other files (Word, Excel) in
other subfolders within the Folder.

In fact, the subfolders are named, Access, Execl, Word, etc.

1. Failed Home Remedy #1. I rebooted all the computers. No change.
2. Failed Home Remedy #2. I moved all the files into a new subfolder.
This worked for one day. Then, the message appeared again the
following day.
3. Untested Home Remedy #3. I moved all the files into a new subfolder
again, but I also deleted some records, thinking maybe the database is
getting to large with 14,000 records. I reduced the number of records
to less than 12,000.

What could be the problem?
What could be the solution?

Thanks,
MHenry

在我的工作中遇到了类似于此的东西。原来

工作组文件（在我们的例子中是system.mdw）位于一些机器无法访问的文件夹中。您的工作组文件是否已被移动，

重置，或者最近是否重置？

-

Mike Storr
www.veraccess.com

迈克，


我不认为文件在问题出现之前被移动或重置了。

但我不确定你的意思是重置？


MHenry


2004年2月18日星期三22:24:55 -0500，Mike Storr< st ****** @ sympatico .ca>

写道：

Hi, Mike,

I don''t think the file was moved or reset prior to the problem.
But I am not sure what you mean by reset?

MHenry

On Wed, 18 Feb 2004 22:24:55 -0500, Mike Storr <st******@sympatico.ca>
wrote:

2004年2月18日星期三17:18:23 -0800，MHenry写道：

On Wed, 18 Feb 2004 17:18:23 -0800, MHenry wrote:

我们用这个数据库快乐地连续工作了6年来记录进入我们办公室的所有客户支票，包括关于支票的信息
。突然之间，网络计算机无法访问数据库。

消息是......

Microsoft Jet数据库se引擎无法打开文件
C：\ SomeFolder \ SomeSubfolder \Somefile.mdb。它已经由其他用户专门打开，或者您需要获得查看其数据的权限。

据我所知，权限没有任何变化，我做了数据库包含许多表，查询，表单和报告。它的重量为3.5 MB。

有些网络计算机在子文件夹中只打开这个文件时出现问题，而其他计算机无法打开任何文件子文件夹中的
文件。在每种情况下，消息都是相同的。文件所在的网络计算机可以打开所有文件。所有网络计算机都可以访问文件夹中其他子文件夹中的所有其他文件（Word，Excel）。

实际上，子文件夹名为Access，Execl， Word等。

1.失败的家庭补救措施＃1。我重启了所有电脑。没有变化。
2.失败的家庭补救措施＃2。我将所有文件移动到一个新的子文件夹中。
这个工作了一天。然后，消息再次出现在
第二天。
3.未经测试的家庭补救措施＃3。我再次将所有文件移动到一个新的子文件夹中，但我也删除了一些记录，认为数据库可能会有14,000条记录。我将记录数量减少到不到12,000个。

可能是什么问题？
可能是什么解决方案？

谢谢，
MHenry

Hi,

We were going merrily along for 6 years using this database to record
all client checks that came into our office, including information
about what the checks were for.

Suddenly, network computers cannot access the database.

The message is...

"The Microsoft Jet database engine cannot open the file
C:\SomeFolder\SomeSubfolder\Somefile.mdb. It is already opened
exclusively by another user, or you need permission to view its data."

So far as I know, nothing has changed with the permissions, and I made
sure no one else had the file open. The only thing I can think of that
might have affected the file is that I may have compacted the database
on Friday and the problem surfaced the next Tuesday. All the computers
on the network can see each other and share data just fine. The
database contains numerous tables, queries, forms, and reports. It
weighs in at 3.5 MB.

Some of the network computers have a problem opening only this one
file in the subfolder, while other computers can''t open any of the
files in the subfolder. In each case, the message is the same. The
network computer on which the files reside can open all the files. All
the network computers can access all the other files (Word, Excel) in
other subfolders within the Folder.

In fact, the subfolders are named, Access, Execl, Word, etc.

1. Failed Home Remedy #1. I rebooted all the computers. No change.
2. Failed Home Remedy #2. I moved all the files into a new subfolder.
This worked for one day. Then, the message appeared again the
following day.
3. Untested Home Remedy #3. I moved all the files into a new subfolder
again, but I also deleted some records, thinking maybe the database is
getting to large with 14,000 records. I reduced the number of records
to less than 12,000.

What could be the problem?
What could be the solution?

Thanks,
MHenry

在我的工作中遇到了类似于此的东西。原来
工作组文件（在我们的例子中是system.mdw）位于一些
机器无法访问的文件夹中。您的工作组文件是否已被移动，
重置或最近？

We ran into something that may be similar to this at my work. Turned out
the workgroup file (in our case system.mdw) was in a folder that some
machines did not have access to. Could your workgroup file have been moved,
reset, or otherwise recently?

MHenry，

1.检查服务器上该文件夹的权限，确保没有人更改它们并关闭对该文件的访问权限。如果是这样的话，Dope打了那个

的白痴。

2.检查Access的每个客户端实例的首选项以确保

没有人专门打开这件事。如果

就是这样的话，Dope打了这个白痴。

2.检查存放文件的硬盘并确保它已经存在

至少20％的可用容量。如果它已经满了，那就去买一个更大的硬盘
驱动器，这样就可以在访问工作时有空间写临时文件。

3.检查所有相关的网络东西，并确保它仍然是稳定的b $ b稳定。访问，（特别是Access 97）可能很挑剔网络

连接。

4.检查文件的属性，确保没有人将其设置为

只读。如果是这样的话，Dope打了那个白痴。

5.运行一个紧凑的&修复文件的*副本*。事实上，尽管当前数据库的存在是好的，但是用它来刻录CD，以防万一，

然后做紧凑的&修复副本。

6.假设以上所有内容都没问题，请创建一个新的Access数据库文件，并将
从您刻录到的文件中导入数据CD进入新文件。

仔细检查导入的数据以确保数据仍然有效&如果不是
，请弄清楚如何处理乱码（我知道乱码不是，不管怎么说，留下我的话）数据。


当服务器发生故障时，您遇到的错误可能会发生错误

，当用户打开文件时锁定该文件并且锁定没有得到
在服务器重新启动时释放，Access在事务中崩溃并且

在它创建的.ldb文件中锁定了一个锁，用于跟踪表/记录上的锁，

等，或者一个同事有一个脑屁并且专门打开这个东西因此

将所有其他人踢出游泳池。如果它是专门打开的并且

服务器发生故障或者访问权限下降那么最后一次知道的文件是
状态是独占的，你必须强制访问或操作系统放开

文件 - 因此建议试用Compact&修理。


" MHenry" < MH **** @ NoSpam.net>在消息中写道

news：kk ******************************** @ 4ax.com ...

MHenry,
1. Check permissions for that folder on your server and ensure that no one
has changed them and shut off access to the file. Dope slap the idiot that
did, if this is the case.
2. Check the preferences of each client instance of Access to ensure that
no one is opening the thing exclusively. Dope slap the idiot that did, if
this is the case.
2. Check the hard drive on which the file is stored and ensure it has at
least 20% of it''s capacity available. If it''s full, go get a bigger hard
drive so access has room to write temporary files as it does its job.
3. Check all the associated networking stuff and make sure it is still
stable. Access, (particularly Access 97) can be finicky about network
connectivity.
4. Check the properties of the file and ensure no one has set it to
read-only. Dope slap the idiot that did, if this is the case.
5. Run a compact & repair on a *copy* of the file. In fact, in spite of
the iffiness of the current database, burn a CD with it as is, just in case,
and then do the compact & repair on the copy(s).
6. Assuming all the above is fine, create a new Access database file and
import the data from the file you burned onto a CD into the new file.
Carefully examine the imported data to ensure the data is still valid & if
not, figure out what to do with the garbledged (I know that garbledged isn''t
a word, leave me be) data.

The error you are experiencing can occur when either the server went down
with a lock on the file while a user had it open and that lock didn''t get
released when the server was restarted, Access crashed mid-transaction and
left a lock in the .ldb file it creates to track locks on tables/records,
etc., or a co-worker had a brain fart and opened the thing exclusively thus
kicking everyone else out of the pool. If it was open exclusively and
either the server went down or Access went down then the files last known
state was open exclusive and you have to force Access or the OS to let go of
the file--thus the recommendation to try a Compact & Repair.

"MHenry" <MH****@NoSpam.net> wrote in message
news:kk********************************@4ax.com...

我们用这个数据库快乐地连续工作了6年来记录进入我们办公室的所有客户支票，包括信息<关于检查的内容。

突然间，网络计算机无法访问数据库。

消息是......

; Microsoft Jet数据库引擎无法打开文件
C：\ SomeFolder \SomeSubfolder \Somefile.mdb。它已经由其他用户专门打开，或者您需要获得查看其数据的权限。

据我所知，权限没有任何变化，我做了数据库包含许多表，查询，表单和报告。它的重量为3.5 MB。

有些网络计算机在子文件夹中只打开这个文件时出现问题，而其他计算机无法打开任何文件子文件夹中的
文件。在每种情况下，消息都是相同的。文件所在的网络计算机可以打开所有文件。所有网络计算机都可以访问文件夹中其他子文件夹中的所有其他文件（Word，Excel）。

实际上，子文件夹名为Access，Execl， Word等。

1.失败的家庭补救措施＃1。我重启了所有电脑。没有变化。
2.失败的家庭补救措施＃2。我将所有文件移动到一个新的子文件夹中。
这个工作了一天。然后，消息再次出现在
第二天。
3.未经测试的家庭补救措施＃3。我再次将所有文件移动到一个新的子文件夹中，但我也删除了一些记录，认为数据库可能会有14,000条记录。我将记录数量减少到不到12,000个。

可能是什么问题？
可能是什么解决方案？

谢谢，
MHenry

Hi,

We were going merrily along for 6 years using this database to record
all client checks that came into our office, including information
about what the checks were for.

Suddenly, network computers cannot access the database.

The message is...

"The Microsoft Jet database engine cannot open the file
C:\SomeFolder\SomeSubfolder\Somefile.mdb. It is already opened
exclusively by another user, or you need permission to view its data."

So far as I know, nothing has changed with the permissions, and I made
sure no one else had the file open. The only thing I can think of that
might have affected the file is that I may have compacted the database
on Friday and the problem surfaced the next Tuesday. All the computers
on the network can see each other and share data just fine. The
database contains numerous tables, queries, forms, and reports. It
weighs in at 3.5 MB.

Some of the network computers have a problem opening only this one
file in the subfolder, while other computers can''t open any of the
files in the subfolder. In each case, the message is the same. The
network computer on which the files reside can open all the files. All
the network computers can access all the other files (Word, Excel) in
other subfolders within the Folder.

In fact, the subfolders are named, Access, Execl, Word, etc.

1. Failed Home Remedy #1. I rebooted all the computers. No change.
2. Failed Home Remedy #2. I moved all the files into a new subfolder.
This worked for one day. Then, the message appeared again the
following day.
3. Untested Home Remedy #3. I moved all the files into a new subfolder
again, but I also deleted some records, thinking maybe the database is
getting to large with 14,000 records. I reduced the number of records
to less than 12,000.

What could be the problem?
What could be the solution?

Thanks,
MHenry

这篇关于网络计算机突然无法访问数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！