Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-16-2019, 12:02 PM   #1
Blancorn
Newly Registered User
 
Join Date: Feb 2016
Posts: 20
Thanks: 1
Thanked 0 Times in 0 Posts
Blancorn is on a distinguished road
Backend database is suddenly getting inconsistent stat

Hello everyone.


With my new application I have already released to my colleagues I 'm facing one big issue which never happened before with all my applications.

Users are connecting to the backend database through frontend installled on their desktop. There are maxiumum 6 users working with database at the same time.

Almost everyday backend database is suddenly getting inconsistent state.
When this happen I need to open backend database and execute compact&repair.

Do you have any idea why my database is getting inconsistent state? Is there any smart way to find a root cause?

In case there is no way to eliminate root cause, maybe is it possible to trigger compact&repair automatically while the user close the frontend?

There is also one constraint: all my users have only runtime installed (no Access full version is available on their PC's).

Thanks in advance for your support.

Blancorn is offline   Reply With Quote
Old 06-16-2019, 12:11 PM   #2
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,358
Thanks: 87
Thanked 1,643 Times in 1,525 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
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.
The_Doc_Man is offline   Reply With Quote
Old 06-16-2019, 12:12 PM   #3
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,937
Thanks: 433
Thanked 284 Times in 249 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: Backend database is suddenly getting inconsistent stat

It sounds as if the DB isn’t split or if it is, someone is using the “master” copy on a shared location.

Is your DB application split and is everyone using their own copy of the Front End on their local PC?

__________________
- Ciao, John
NauticalGent is offline   Reply With Quote
Old 06-16-2019, 12:30 PM   #4
Blancorn
Newly Registered User
 
Join Date: Feb 2016
Posts: 20
Thanks: 1
Thanked 0 Times in 0 Posts
Blancorn is on a distinguished road
Re: Backend database is suddenly getting inconsistent stat

Database is already split.
Backend contains only tables.
Users have on tge desktops frontend whichcontains forma and queries.
Blancorn is offline   Reply With Quote
Old 06-16-2019, 12:34 PM   #5
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,769
Thanks: 55
Thanked 1,022 Times in 988 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Backend database is suddenly getting inconsistent stat

maybe this

https://www.devhut.net/2018/06/13/ac...gnized-format/

If it should work, but then started to produce this error …..
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
The Following User Says Thank You to gemma-the-husky For This Useful Post:
NauticalGent (06-16-2019)
Old 06-21-2019, 05:09 AM   #6
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,358
Thanks: 87
Thanked 1,643 Times in 1,525 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Backend database is suddenly getting inconsistent stat

See also the "sticky" at the top of this forum on "Renaming databases..." You have to dig into it a bit, but it gives an explanation similar to the one posted by Dave.

The whole problem apparently stems from trying to make network traffic better for file sharing, and in the process, Microsoft made SMB traffic worse for Access. They did so by allowing deferred caching protocols which run the risk of keeping buffers open longer. Which in turn increases the size of the time-window during which bad network events can destroy the validity of a disk buffer. And that is where corruption drops into your lap. The apparent solution (IF this is the source of the problem) is a way to disable the new option that would allow longer deferrals on buffer write-back operations.

__________________
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.
The_Doc_Man is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database in Inconsistent State ErinL General 12 05-30-2019 11:44 AM
Inconsistent State, unable to open backend mjdemaris General 27 09-12-2018 09:53 AM
Database in inconsistent state error SAE General 15 03-02-2018 09:44 AM
[SOLVED] Database in inconsistent state boerbende General 7 03-02-2016 09:00 AM
Count NULL togerther w/ “No Stat” records jasminewhite Queries 12 12-13-2011 08:44 PM




All times are GMT -8. The time now is 08:01 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World