CODEWITHSUNDEEP
ms-access
nathanjw
nathanjw

Reputation: 1062

Is it possible to trap the "Access is in an inconsistent state" error?

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.

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.

Upvotes: 2

Views: 669

Answers (1)

Gustav
Gustav

Reputation: 56026

.. 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.

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.

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.

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:

Deploy and update a Microsoft Access application in a Citrix environment

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

Upvotes: 3

Related Questions