I have a MS Access 2010 database that has been running with no issues since 2015. The database is split the back end of the database resides on a file server Windows 2008 server R2. Each user has their own copy of the front end on the same server with a shortcut on their desktops. Most users are running Access run time 2010, only 1 or 2 copies of the full application of access. The company recently completed an upgrade to Windows 10. However many users had been on Windows 10 with no issues. The database keeps being “Microsoft Access has detected that this database is in an inconsistent state.” I will open the back end and it will recover. I will perform a Compact and Repair on the back end and the system will work. But then it will happen again. I am looking for any help on how to find what is causing this and recommendation for any 3rd party repair tools that you may have used to assist in resolving this issue.
Thanks for you help.