Access 365 error msg database is in an inconsistent state,

%3CLINGO-SUB%20id%3D%22lingo-sub-2170517%22%20slang%3D%22en-US%22%3EAccess%20365%20error%20msg%20database%20is%20in%20an%20inconsistent%20state%2C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2170517%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20database%20does%20not%20open.%26nbsp%3B%20Error%20msg%20MS%20has%20detected%20this%20database%20in%20inconsistent%20state%2C%20will%20attempt%20to%20recover%20the%20database%2C%20and%20make%20a%20backup%20copy.%26nbsp%3B%20Access%20will%20then%20open%20the%20new%20database.%26nbsp%3B%20Click%20OK.%26nbsp%3B%20Then%20msg%20to%20open%20new%20database%20and%20check%20for%20accuracy.%26nbsp%3B%20But%20nothing%20opens.%26nbsp%3B%20I'm%20dead%20in%20the%20water.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2170517%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

My database does not open.  Error msg MS has detected this database in inconsistent state, will attempt to recover the database, and make a backup copy.  Access will then open the new database.  Click OK.  Then msg to open new database and check for accuracy.  But nothing opens.  I'm dead in the water.

2 Replies

@Terry4820 

There are a couple of possibilities.

One is that something in your specific environment caused corruption in that specific accdb. More on that below.

The other is that you've fallen victim to a long-running problem that has plagued some Access users. This discussion, although it is rather lengthy, is probably a good place to start.

 

Some of the reasons for a specific accdb to become corrupted include trying to use it remotely via a Wireless connection, improperly shutting down a running accdb by doing something like power off, or disconnect from a network, and simply things going bad.

 

If it's the latter, you can try some of the methods outlined here. Allen Browne is retired, but his site is still at the top of the list for basic trouble-shooting.

 

If you tried to run an accdb via Wireless, you may have experienced the corruption caused by intermittent fluctuations in signal strength.

If you tried to run an accdb from OneDrive or DropBox, they are often the source of problems like this.


Good luck sleuthing out your specific problem.

This may happen when you have a database stored on a network file share, and multiple users are using the database simultaneously.
You can check this question:
https://techcommunity.microsoft.com/t5/access/microsoft-access-database-app-error-3046/m-p/1074354