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.
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?
The main issue with SharePoint is the list size limitation (5000). If you plan on a db tables with large recordsets SharePoint just won't do.
I just had a meeting with our db who converted 12 Access backend db's to SharePoint. No data corruption issues, better performance, optional on whether or not you need to connect to the company's VPN for these Access db's. Still more questions as I do a deeper dive into the SharePoint - Access backend db, but it does look promising.
Given that MS won't actually address this data corruption issue after over 2 years, we db developers have to get creative. I still believe that Access is a great, durable application (especially for small to medium size businesses) which MS has yet to find a good equivalent replacement for.