Microsoft Access只读后端间歇性 [英] Microsoft Access read-only back end intermittent

问题描述

你好，


我的数据库后端出现间歇性问题。


间歇性地，后端表将变为只读。仅当后端位于网络共享上时才会发生这种情况。


这不是权限问题，因为当以同一用户身份登录时，问题只会间歇性地发生。


如果我打开后面-end数据库本身，然后是前端客户端（在本地驱动器上）这个问题就消失了。


一旦后端被设为''只读' '，我必须自己打开并再次关闭它以使表格可编辑。


任何想法？


Jon

Hello,

I''m having an intermittent problem with the back-end of my database.

On an intermittent basis, the back-end tables will become read-only. This only happens when the back-end is located on a network share.

It isn''t a permissions issue because the problem occurs only intermittently when logged in as the same user.

If I open the back-end database on its own and then the front-end client (on the local drive) this problem goes away.

Once the back-end has been made ''read-only'', I have to open it on its own and close it again to make the tables editable.

Any ideas?

Jon

推荐答案

您是否尝试过使用持续连接？ Microsoft Access Performance FAQ

Have you tried using a Persistant Connection yet?Microsoft Access Performance FAQ

我已经解决了！我读到了使用持久连接。谢谢RuralGuy！

我让数据库打开一个隐藏的表单链接到我的数据库中的虚拟表。这个表单总是在后台打开，并且与后端数据库同时打开相同。


如果我关闭，我仍然有一个小问题数据库然后快速再次打开它;这往往使后端只读。我想这可能与记录锁有关。


任何关于如何停止此操作的想法，可能是通过检查后端的锁并等待当时是否关闭？我不知道怎么做...

I''ve solved it! I read up on using a persistent connection. Thanks RuralGuy!
I have the database open a hidden form linked to a dummy table in my database. This form is always open in the background, and it''s the same as having the back-end database open at the same time.

I still have a minor problem if I close the database and then open it again quickly afterwards; this tends to make the back-end read-only. I guess this might be to do with record locks.

Any idea on how to stop this, perhaps by checking locks on the back-end and waiting if it is being closed at that moment? I wouldn''t know how to do this...

你可以在打开BE之前检查.ldb文件。

You can check for the .ldb file before opening the BE.

这篇关于Microsoft Access只读后端间歇性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！