MS Access 2016 database, split into front end and back end, backend on a LAN, 140k records in the largest table, other tables very small,
Database ran well for several weeks, drives replaced on server, database ran for a couple of days OK but now queries that used to take 10 seconds take 5 minutes or stop.
I have compressed front and back end several times.
what can be wrong?
Thank you very much for your help.