清除错误3045 [英] Clearing Error 3045
问题描述
由于错误3045 - 正在使用文件，我无法压缩或修复Access 97数据库。
如果我关闭数据库，则没有ldb文件保持打开状态，因此不应锁定数据库，并且没有其他用户登录到我们服务器上的数据库。
我可以将数据库复制到另一个文件夹，压缩它并将其复制回来没有任何问题，但服务器版本仍然是显然已被锁定。如果文件不在ldb文件中，那么它在何处被保存？我能否以任何其他方式重新设置此设置？
我对此有任何想法。
Dave Slade
Cardiff
I cannot compact or repair an Access 97 database due to Error 3045 - File in use.
If I close the database, there is no ldb file left open, so the database should not be locked, and there are no other users logged into the database which resides on our server.
I can copy the database to another folder, compact it and copy it back with no problems, but the server version is still apparently locked. Where is this file lock infrormation held if it is not in an ldb file? Can I re-set this setting in any other way?
I''d apreciate any thoughts on this.
Dave Slade
Cardiff
推荐答案
由于错误3045，我无法压缩或修复Access 97数据库 - 正在使用的文件。
如果我关闭数据库，则没有ldb文件保持打开状态，因此不应该锁定数据库，并且没有其他用户登录到驻留在我们服务器上的数据库。
我可以将数据库复制到另一个文件夹，压缩它并将其复制回来没有任何问题，但服务器版本仍然显然已被锁定。如果文件不在ldb文件中，那么它在何处被保存？我能否以任何其他方式重新设置此设置？
我对此有任何想法。
Dave Slade
Cardiff
I cannot compact or repair an Access 97 database due to Error 3045 - File in use.
If I close the database, there is no ldb file left open, so the database should not be locked, and there are no other users logged into the database which resides on our server.
I can copy the database to another folder, compact it and copy it back with no problems, but the server version is still apparently locked. Where is this file lock infrormation held if it is not in an ldb file? Can I re-set this setting in any other way?
I''d apreciate any thoughts on this.
Dave Slade
Cardiff
当数据库打开时，ldb文件是否出现在您希望的位置？
When the database is open does the ldb file appear where you expect it to be?
当数据库打开时，ldb文件会出现在您希望的位置吗？
When the database is open does the ldb file appear where you expect it to be?
是的。
Yes it does.
是的。
Yes it does.
当你压缩并修复文件时，即使文件被另一个用户锁定，数据库也会先复制自己，然后覆盖自己，这样它就应该创建一个自己的副本。文件夹，即使文件被锁定，所以我不认为这是你的问题。
你说你复制文件并压缩并修复没问题。你是在同一个文件夹中这样做的吗？我想知道的是，问题是文件夹中的写入特权是否比数据库本身更多。
我能想到的唯一其他选择是存在腐败，但这不是如果你可以复制它和它的罚款，那就没有意义。
Mary
When you compact and repair even if the file is locked by another user the database copies itself first and then overwrites itself so it should be creating a copy of itself in the folder even if the file is locked so I don''t think this is your problem.
You say you copy the file and compact and repair it no problem. Are you doing this in the same folder. What I am wondering is if the problem is more one of write privilages in the folder than the database itself.
The only other option I can think of is that there is corruption but this doesn''t make sense if you can copy it and its fine.
Mary
这篇关于清除错误3045的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
