Re: Backend database is suddenly getting inconsistent stat
Typically, "Inconsistent state" comes about when someone closes their application in a way that doesn't correctly preserve data being written back to the back-end file. For instance, rebooting a computer or pulling the power plug on a busy front-end. Networking issues can also do this because the FE/BE connection uses the Server Message Block protocols (the same as used for Windows File Sharing). Therefore, a network glitch has the potential to whack you every time.
Is everyone on the same version of the Access Run Time? Was the app developed on the same version of Access (full) corresponding to the version of Access (run-time)?
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.