MS Access 数据库被未知用户锁定
我有一个位于多个用户可以访问的网络驱动器上的访问数据库。今天早上数据库损坏了，我正在尝试修复它。我遇到的问题是，当我尝试重命名数据库时，它说它当前正在被某人使用。没有与此文件关联的 .ldb 文件，因此此时我已经死在水中，因为我无法重命名它，压缩它或任何东西。
有人有什么建议吗？
谢谢
I have an access database that is on a network drive that multiple users can access. The database corrupted this morning and I am in the process of trying to fix it. The problem I am having is when I attempt to rename the database it says it is currently in use by someone. There is no .ldb file associated with this file so at this point and am dead in the water because I can't rename it, compact it or anything.
Does anyone have any suggestions?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
将数据库复制到另一个位置。副本不会被锁定。然后您可以采取多种方式保存您的工作，直到解决原始文件中的锁定问题。如果您的问题是由于 VB 代码文件损坏引起的，请尝试使用“/反编译”选项打开数据库：
开始-运行：
“C:\Program Files\Microsoft Office\Office\msaccess.exe”“C:\example.exe” mdb" /decompile
如果您没有任何与 mdb 关联的 ldb 文件，则很难发现哪个用户正在锁定您的数据库。如果您的用户很少，您应该重新启动他们的计算机。这将是史前的，但应该比尝试通过其他方式解锁文件最快。
Copy the database to another location. The copy wont be locked. Then you can work in ways to save your work until you solve the lock problem in the original file. If your problem is due to VB code file corruption, try to open the database with the "/decompile" option:
Start-Run:
"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\example.mdb" /decompile
If you haven't any ldb file associated with the mdb, it will be difficult to discover what user is locking your database. If you have few users, you should restart their machines. It would be prehistoric but should be fastest than trying to unlock the file through other ways.
只需执行此操作，尝试“F11”，然后选择“表格”，选择主题并单击“打开”，从那里将一个简单的 C&P 转换为 Excel 工作表。
希望这有帮助
戴夫·普拉格内尔
Just had to do this, Try "F11" then select "tables", select topic and click open, from there it a simple C&P into excel sheet.
Hope this helps
Dave Pragnell
ldb 文件是在第一个用户打开数据库时自动创建的，它跟踪打开数据库的用户数量以及每个对象的锁定状态
因此，如果一个用户以只读方式打开，那么第二个用户可以编辑数据库，
当最后一个用户关闭与数据库文件的连接时，该文件会自动删除。
您不要手动删除/修改此文件，因为这可能会导致数据库状态不一致
您可以在记事本中打开此文件并检查有多少用户打开了此文件，但不要更改任何内容。
ldb file is automatically created when first user opens the DB, it tracks the number of users who have opened the DB and locking status of every object
so if one user is open in read only then 2nd user can edit db
this file automatically deleted when last user close connection to the db file.
You dont manually delete/modify this file, as it may result into inconsistent state of DB
You can open this file in Notepad and check how many users have opened this file, But DONT change anything.