There are several databases written in MS Office Access, with similar architecture. The databases are divided into a tabular part (which is stored on the server) and an interface (requests-forms), which are located on the user workstations.
There is a problem of slow loading of forms, transition through records, especially when many users work simultaneously.
It is necessary to analyze one of the databases; identify the reasons for slow work; and make changes to the database (in agreement with the Customer) - without loss of functionality - that will significantly increase the speed of the bases.
P.S. The experience of integrating PBX into Asterisk and the bases on Access (this is another project) is welcome.