共享数据库已锁定 - 无法更新 - Access 2000 - 帮助！ [英] Shared database locked - cannot update - Access 2000 - Help!
问题描述
我在Access 2000中遇到多用户数据库问题。
数据库用于记录调用我的公司最多可以使用30人，但目前大约有10人正在使用它。
我已将数据库拆分为前/后端，每个用户都使用本地副本通过我们的网络连接到后端的前端。
当我们测试它（在2个不同的站点上）并且没有任何问题时，一切正常，但现在，一些新用户正在使用它，我不断遇到无法保存/更新记录的问题，并且无法更新 - 当前已锁定消息 - 这意味着所有用户都开始遇到相同的问题。如果每个人都注销它就可以解决问题。
默认开放模式=共享
默认记录锁定=无锁
打开数据库使用记录级锁定= true
请有人帮忙解决这个问题 - 我不知道为什么会这样，需要快速解决。
Hi,
I have a problem with a multi-user db in Access 2000.
The db is for logging calls to my company and will be used by up to 30 people, though currently around 10 are using it.
I have split the db into front/back end and each user is using a local copy of the front end, connected to the back end via our network.
It was all working fine when we tested it (across 2 different sites) and had no problems, but now, some new users are using it and I keep getting a problem where they cannot save/update a record and get the message "cannot update - currently locked" - this then means that all users start to experience the sameproblem. If everyone logs out it solves the problem.
Default Open Mode = shared
Default Record Locking = No locks
Open databases using record-level locking = true
Please can someone help with this - I''m not sure why this is happening and need to sort it out quickly.
Many thanks,
推荐答案
任何人都可以帮忙解决这个问题吗？
can anyone help with this?
我是否严重地表达了我的问题或只是没有人知道我为什么会遇到这个问题？非常感谢某种回应。
非常感谢，
Olly
Have I phrased my question badly or is it just that no-one knows why I could be having this problem? Some sort of response would be greatly appreciated.
Many thanks,
Olly
我是否严厉地表达了我的问题，或者只是没有人知道我为什么会遇到这个问题？非常感谢某种回应。
非常感谢，
Olly
Have I phrased my question badly or is it just that no-one knows why I could be having this problem? Some sort of response would be greatly appreciated.
Many thanks,
Olly
这种不耐烦，Olly--一般来说，没有回应意味着我们也不知道！
-Stewart
Such impatience, Olly - generally, no response means we don''t know either!
-Stewart
这篇关于共享数据库已锁定 - 无法更新 - Access 2000 - 帮助！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
