是否有可能捕获“访问处于不一致状态"?错误? [英] Is it possible to trap the "Access is in an inconsistent state" error?

问题描述

我有一个Access 2013数据库，该数据库跨网络分布，主要通过Citrix使用.我不断收到错误消息，指出数据库处于不一致状态，但我不知道为什么.我创建了一个查询以将用户名和计算机ID捕获为auto-exec宏，因此我可以回去询问用户发生了什么等.但是我想知道的是，是否有可能知道第一次遇到哪个用户这个错误?我可以以某种方式捕获该错误并知道哪个用户引起了"错误吗?我感觉到此错误发生在auto_exec宏触发之前，但是我希望如此.

I have an Access 2013 database split across a network that is mainly used via Citrix. I keep getting the error message that the database is in an inconsistent state and I don't know why. I created a query to capture the user name and machine id as a auto-exec macro so I can go back and ask users what happened etc. But what I'd like to know is if it would be possible to know which user first encountered this error? Can I trap the error somehow and know which user "caused" it? I have a feeling that this error happens prior to the auto_exec macro firing but I live in hope.

我希望能够与Citrix团队联系，看看他们是否有相应的错误或日志中有什么内容.

What I am hoping to be able to do is get with the Citrix team and see if they have a corresponding error or something in their logs.

推荐答案

..可悲的是他们都共享同一个前端.它只是被使用 用于只读查找.我希望每个用户都有自己的 复制，但IT与我不同意.

.. sadly they are all sharing the same front end. It's only being used for read-only lookup purposes. I wanted each user to have their own copy but IT disagreed with me.

唯一可靠的方法是，将accdb文件本身标记为只读，这可能会使您的应用程序无用.

The only way it could work reliably, is if the accdb file itself is marked as Read-Only, and that would probably leave your application useless.

我一直通过一个客户端为优先级高的应用程序运行大型Citrix设置(40000多名员工)来解决此问题. IT出于某种原因对安全性有严格的看法，但是尽管合作非常紧密，但对他们的帮助却很小.

I've been through this with a client running a huge Citrix setup (40000+ employees) for an application with a priority. IT had for a reason a strict view on security, but though quite cooperative, they were of little help.

但是，我通过VB脚本解决了该问题.第一次尝试就成功了，效果很好，我在这里写了一个描述:

However, I got it solved by a VB script. It worked in the first attempt and so well, that I wrote up a description here:

在Citrix环境中部署和更新Microsoft Access应用程序

很棒的是，您可能不需要IT来为您做任何事情.

The great thing is, that you probably won't need IT to do anything for you.

这篇关于是否有可能捕获“访问处于不一致状态"?错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！