Inconsistent State Error, Urgent

Resolved · Urgent Priority · Version 2013

Mon 7 Oct 2019, 17:08 Delegate Manny said...

Manny has attended:
Access Intermediate course
Access Advanced course

Inconsistent State Error, Urgent

Hi Jens & All,

i need some urgent help with this.

I intermittently (every other day) am getting a "inconsistent state" error.

the back end is moved to a SQL database (with the exception of 5 local tables) and the front end is still access.

Apologies, i am unable to offer much on this situations as i am really struggling to pinpoint the exact reason for the error. The only thing i could think of is that there has been an inflow of new computers (windows 10) i developed the application in windows 7.

Please may you advise on what steps i can take to remediate the issue?

Manny

Mon 7 Oct 2019, 19:21 Trainer Jens said...

RE: Inconsistent State Error, Urgent

Hi Manny,

I assume you have seen this:

https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state- %EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d

Can it be that every other day there is more than one working in the database.

And:

http://www.accessrepairnrecovery.com/blog/fixes-to-resolve-access-database-inconsistent-state-error

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 8 Oct 2019, 08:17 Delegate Manny said...

RE: Inconsistent State Error, Urgent

Hi Jens,

Yes I have read the link you have suggested. Unfortunately, i am not brave enough nor do i have the permissions to run the "work around".

Multiple users use the front end at the same time. It has worked fine for 10 months and has only started to happen recently.

I have just compacted it again now however, i fear this is not the solution. I may try and rebuild it the application on a windows 10 computer?

Do you have any other suggestions? Apologies, i really do not have much to offer, its been rather painful looking for a solution when i am not even sure what the problem is!

Manny

Wed 9 Oct 2019, 12:14 Trainer Jens said...

RE: Inconsistent State Error, Urgent

Hi Manny,

Yes that's a nightmare.

I am sorry but I haven't much experience with the error you get, and I am as you afraid of guiding you in a wrong direction, which can cost you hours and hours of work to rebuild.

I do not know if you have tried the "Analyze Performance" tool on the Database Tools tab. Sometimes it has helped me with errors. If you select all objects the tool may spot the problem.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 8 Nov 2019, 09:38 Trainer Claire said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 6 Feb 2020, 14:45 Manny (guest) said...

RE: Inconsistent State Error, Urgent

Hey Jens,

This is apparently a very common problem with windows 10!

https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state- %EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d

Frustrating microsoft hasn't come up with a fix yet....

Manny

Fri 15 Nov 2019: Automatically marked as resolved.

Training courses