I have created a number of frontend/backend databases which are used to service users on a network. The Tables reside in the backend on the server and the front end is loaded locally on each machine. The backend is in Access97 to cater for various versions of Access being loaded on the front end machines. All later versions are happy to attach to the 97 tables. The backend contains only the tables, the front end contains all required queries and coding to perform the required functions.
Here is the problem. The more users that open the database (or at least their front end) the slower the database responds. I'm sure there must be a tweak to the refresh rate or some work around to at least maintain a respectable response time for all users, but til now I haven't found a solution.
I would be glad to hear from anyone who has any ideas or has solved this problem themseleves.
Here is the problem. The more users that open the database (or at least their front end) the slower the database responds. I'm sure there must be a tweak to the refresh rate or some work around to at least maintain a respectable response time for all users, but til now I haven't found a solution.
I would be glad to hear from anyone who has any ideas or has solved this problem themseleves.