Hello experts. I have a 7-user application which slows down significantly when more than one user logs in. It is a FE/BE set-up. All users log into a single server via Remote Desktop. The BE and FE are on the server. A batch file copies the FE with the user's network login appended to the filename -- so all users are working in their own FE. I have done the following: turned Name Autocorrect off, I set sub-datasheets to None in all the BE tables, I have insured that there is no looping code anywhere, etc.
Their IT group is evaluating the server's hardware performance right now -- checking logs, etc.
The application has one continuous-forms form which is tabbed -- where the tabs filters the view based on the tab - and at any given time a view only has up to 50 records or so -- the underlying recordsource contains 2 linked / related tables with approximately 1000 records.
When 1 user is logged in, this form flies. As each subsequent user logs in, performance degrades significantly. No more than 3 users are in this form at a time ---
I am at a loss as to what to check next. My client has assumed it's the application, but I think it may be environmental.
I intend to go in there Monday and move the FE and BE to a local LAN to test the application's performance on that platform.
If it's a design flaw, I can live with that. I have not been billing for my time over the past couple of weeks because if it is the application, then I need to fix it -- and eat the cost. If it winds up being environmental, then I'll need to recoup some of my time in terms of billing.
I'm looking for some advice and direction so I can be prepared if the LAN scenario doesn't improve things.
Thanks for any suggestions.