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.
Tom, please define what you mean by "real database work" when we are referring also to Access. Many database designers/developers don't consider Access a "real database" and strongly suggest fully converting to SQL or Oracle as soon as possible.
David, I have been researching this as a possible option but am not sold on it. If it proves to be an ineffective solution, I will no longer pursue it.
I find it ironic that Microsoft views a potential solution negatively when they have done basically nothing to effectively fix this Access data corruption issue for the past 3 years.
I found this article - Thoughts ?
https://sharepointmaven.com/how-to-overcome-sharepoint-5000-item-limit-threshold/
![](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(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Search online for "sharepoint 5000 records". I don't consider it a viable option for real database work.
I see that Microsoft suggest SharePoint as a possible solution for "light workloads", although of course they do not define this. On reading more about how data is stored in SharePoint (apparently all in one SQL Server table) and its limitations, it seems to me wholly unsuitable for any moderately complex or sizable database application. Maybe someone can describe a database which is working well with a SharePoint back-end, so that readers have some idea whether its worth taking the time to test their own application?