inconsistent state error urgent

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Inconsistent State Error, Urgent

Inconsistent State Error, Urgent

resolvedResolved · Urgent Priority · Version 2013

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

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

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

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

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.

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

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Server loaded in 0.06 secs.