We're having an issue at the moment with an access database repeatedly going corrupt. We've been restoring it from shadow copies for now but this obviously isn't a feasible long term fix.
The database itself is on a file server (running Server 2008 R2), and is accessed one of two ways: via Access 2019 on some users desktop machines, and the rest of the users via Access 2010 on a virtual terminal server running 2008 R2.
The issues first arose after office was updated (including access) to 2019 for the desktop users, so I'm pretty sure it's the database being accessed by two different versions that's causing issues.
Does anyone know if there is a way around this? We'd have liked to upgrade the server to Access 2019, but it seems that it needs to be running server 2019 to do so, and we'd ideally like to avoid having to upgrade the Server OS.