This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
We have an application which was working okay till last month. But after the last windows update our clients are getting issues with access database. access database got corrupted. We ran compact and repair. But it still getting corrupted again and again. This issue started right after the window update. clients are on different OS. Like server 2018, server 2012 and windows 10.
Is there anything i have check in new windows update or any other step to prevent database corruption?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Thank you so much,
Do I need to revert back for all users or just the main admin ? Just saw today's update by Microsoft for this type of issue, very frustrating.
I am not sure it will work as our IT department controls all the update etc.
Consider rolling back to your prior version of Access (Access 2013 ?). I've tried all sorts of solutions since Nov 2019. This seems the best option for now, until it is necessary to convert the backend to SQL Server.
Also moving to other backend database folders provided some temporary relief.
I am having the same issue , access database in "inconsistent state" since last 1 week. It shows the message that database is in inconsistent state, will attempt to recover. During this, a backup will be made and recovered objects will be in new database. Name of objects not recovered will be in a "Recovery Error" table.
Already occured 5 times in this week, there was no issue with the database for last 9 years. I am in Healthcare, and all updates are controlled by IT. There are 5-7 users at the same time on same server. Windows : 10 (1803). Database is in mdb format. Access : 2016
Been dealing with this Access 365 (aka Access 2016) issue since Nov 2019. Continued database corruption issues. MS doesn't seem to give a flip about this well-known issue after over 2 years. Terribly frustrating.
While I know this has been identified as a "Windows 10" upgrade issue, there are a couple developers here doing fine rolling back their Access 2016 db's to Access 2013, which is what I'm going to do. If any further database corruptions after this rollback, I will convert my backend database to SQL Server.
Hi to all.
Does any one tested the BE ACCDB to be on an Ubuntu machine ?
Since that there is no need for an SQL (by the way we can have SQL on Ubuntu) then the Server 12 R2 is the "mother" of the issues.
I have many installations :
Sample 1 --> WorkGroup environment with a shared drive of one client (3-5 users). No problem at all. NO LOCAL TABLES use.
Sample 2 --> WokGroup with the BE accdb on Ubuntu 18.09 system. No Problem at all. NO LOCAL TABLES use
Sample 3 --> Server 12 R2. The hell it self with NO LOCAL TABLES. If LOCAL TABLES are on then it's ok (not tested hard yest).
Conclusion --> ALWAYS SAVE LOCALLY and then with : Currentdb.Execute "Insert Into MainTable Select * from LocalTable", dbfailonerror
One way or another the Win 10 Pro is a mess.
Microsoft is a mess too.
Nonprofessionals with out giving attention to million users/developers of Access.
I working on to leave from Microsoft and to move in a web app status with MySQL. This is the final solution. A business environment full of Linux Clients & Servers with out MS critical systems at all.