We have a network of 11 workstations that can be potentially logged into our Access2003 application at the same time.
One form in that application includes a very complex query. When one person is logged into the application, the response time for this form is fairly quick (20 secs). However, even with 2 additional people logged in, the performance for this form degrades dramatically (1-2 mins+)
. There is a coded safeguard in the calling form preventing multiple people from using this form for the same calling parameter.
Any help on this would be appreciated.