multiple user accessing table slowing down application

[chiefvj]

I have a Access application with front end( forms, queries, reports) on 4 desktops and the back end (tables)on a network server. The problem, one user accessing the tables and the application loads and excute searches very fast. More than one user accessing the tables at the same time and the process slows to a crawl.

Any ideas why...THX

 

[Ed2020]

There are lots of tweaks you can apply to improve performance in a multi-user system. I got the biggest gains from these:

1. Maintain a persistent connection to the backend database(s).

http://granite.ab.ca/access/performanceldblocking.htm

2. Turn off Name Autocorrect.
3. Turn off sub-datasheets.

There is a good list of recommendations here:

http://www.granite.ab.ca/access/performancefaq.htm

Ed Metcalfe.

Please do not feed the trolls.....