Hi there,
Our Access database is getting a bit sluggish when loading/running reports. My mate said to me that the Access database that our 100+ users at work use to run reports should be "stripped back" to speed things up and to stop unnecessary actions running when they aren't needed. He pointed me in the direction of File>Options. Users don't edit data from this database, just to run preset reports. They have no editing capabilities either.
Can anyone give me any tips as to what I can change in the backstage please? Our users do not use the developer side of things, they just get a few forms with buttons to reports to run. I've took print screens of the current set up.
Our Access database is getting a bit sluggish when loading/running reports. My mate said to me that the Access database that our 100+ users at work use to run reports should be "stripped back" to speed things up and to stop unnecessary actions running when they aren't needed. He pointed me in the direction of File>Options. Users don't edit data from this database, just to run preset reports. They have no editing capabilities either.
Can anyone give me any tips as to what I can change in the backstage please? Our users do not use the developer side of things, they just get a few forms with buttons to reports to run. I've took print screens of the current set up.