2010 Ms Access Record Locking, inconsistent state

Hello All,
We have about 10 users using Access 2010 Front End and Back End database
The last few days we got a message on the Front End "Microsoft access has detected that this database is in an inconsistent state"
and we had to replace the Front End mdb.
Today we got a message while entering a new record "Could not update, currently locked" and we compacted the Back End and it's good for now.
We have a 2012 server it was working fine for a year
Please let me know what to do.
Thanks in advance
LVL 1
frimyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
Is the application properly split?  I.e. the users have their own personal copy of the FE and the BE is on a network share.

Do you compact the BE regularly?

If you use temp tables and certain other types of processing in the FE that leads to bloat, do you compact the FE regularly?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
In addition to Pat's suggestions - the error messages you're getting would seem to indicate corruption, which is often caused by faulty network connections, or by trying to use Access across a wireless or WAN connection.

Of course, if your database is not split, as Pat suggested, then all bets are off. You simply cannot have a reliable multi-user Access application unless it's split, and each user has their own locally stored copy of the FE.
frimyAuthor Commented:
Thanks Pat and Scott,
I am doing all the suggestions from Pat.
I spoke to the IT person, he also suggested to optimize the server like Scott suggested.
Thanks you all
Have a nice day
Frimy
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

frimyAuthor Commented:
Hello Jim,

Do you remember me.
I think we found the culprit.
One day walking home I remembered that we had problems with the On timer event.

On our Order Form (where we had the most problems and record locking and missing records)
we had an On Timer event to make a control to blink on certain condition.

We took of the blinking option and the On timer event, guess what??? the record locking disappeared.
But we still had some minor issues i.e. reserved errors.
We put back all the Access default settings and we didn't have any record locking and missing records already three weeks.

Jim, Thanks again for your help in our difficult days.
You really helped me a lot.
I wish the best to you and your family

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Looks like you found your solution, so please accept your last comment as the answer. This may help others down the road with similar problems.
frimyAuthor Commented:
I just wanted to send a message to Jim
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Jim(?) didn't participate in this question, but you could use the EE messaging feature to reach out to him.
frimyAuthor Commented:
I would like to close this question.
Thank You
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.