I work for a Managed Service provider and do not have much experience with Access.
One of our Customers has an Access 2016 database that is split so multiple user can work with it.
The backend is on a server and the front end is located in a share on the same server
The customer has tried to clean up and simply the database
It has at least 1 index and they have done a compact and repair to the database.
We are checking to make sure it is excluded from Webroot scans
My question is, does the database re-index each time it is opened? if not, would it help to re-index and if so can someone walk me through the process?
Thank you,