98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Inconsistent State Error, Urgent
Inconsistent State Error, Urgent
Resolved · Urgent Priority · Version 2013
Mon 7 Oct 2019, 17:08Delegate 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:21Trainer 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:17Delegate 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:14Trainer 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:38Trainer 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:45Manny (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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Creating Parameter wildcard queriesTo creat a parameter query that also uses a wildcard, in the query design type in like []+*. |
