Administration program for a non profit organisation, that organizes courses and has 800 members. Front-end Access2016 with backend mysql dB; works fine. We work with 5 volunteers in different locations; they have access to read and write.
You start the admin program by selecting an administration year. The selected year is saved in the field 'Year' in a backend table 'General'. Program responds with forms and reports that belong to the selected year.
All goes well if all volunteers work in the same year. Problem arises when person A selects year 2021 and person B follows later and selects 2020. B overwrites the field 'Year' in table 'General' and person A notices that the year has changed form 2021 into 2020. Hence it is impossible to work in 2 different years by 2 persons at the same time.
I thought to have found a solution to the problem by moving tbl 'General' from mysql backend to Access2016 frontend. It did solve that problem but created a new problem i.e. ; reports involving 5 different tables give a very slow response, up to 30 secs.
Please help with suggestions on how to solve this response problem with the reports.
You start the admin program by selecting an administration year. The selected year is saved in the field 'Year' in a backend table 'General'. Program responds with forms and reports that belong to the selected year.
All goes well if all volunteers work in the same year. Problem arises when person A selects year 2021 and person B follows later and selects 2020. B overwrites the field 'Year' in table 'General' and person A notices that the year has changed form 2021 into 2020. Hence it is impossible to work in 2 different years by 2 persons at the same time.
I thought to have found a solution to the problem by moving tbl 'General' from mysql backend to Access2016 frontend. It did solve that problem but created a new problem i.e. ; reports involving 5 different tables give a very slow response, up to 30 secs.
Please help with suggestions on how to solve this response problem with the reports.