• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 648
  • Last Modified:

Slow server

I recently installed an application in a multi user environment. (That part sound like I know what I am doing. The next bit doesn't) All computers work fine except for one that seem to be slow, then I get an error "The on open event of your report triggered something" That's not exactly what it said. The next error, still tying to open the same report, said that the query was too complex and that I should remove some fields or make it less complex"

The same app on other machines works fine. Could it be A, Something to do with slow connection or B, two people opening the same report or C, I seem to remember  in the options of Access something like Refresh rate, or retries???

  • 2
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
In general, if you have one problem machine in a multi-machine environment then you have something amiss with that machine. First thing to do is be sure that all Office and Windows updates are fully up to date.

Next, check the network hardware associated with the machine. The NIC, for example, could be bad, or the cable between the NIC and router/switch. You can purchase testing equipment for this, or just swap them out with a known good replacement. If you have switches or routers in the path to the server you'd also need to check them. Quite often you'll find a loose connection, or something of that sort.

A corrupt user profile can wreak havoc on performance as well. Try logging into the problem machine as a different user. Do the performance issue go away? If they do, then you'd need to recreate the user profile for the trouble user.

Printers have an impact on Access, especially in regard to reports. Be sure that the problem machine has a valid default printer, and that it works.

Regarding multiple users - you are apparently working with a split architecture, where you have a BackEnd (tables only) and a FrontEnd (everything else). When you did this, did you deploy a COPY of the FE to each machine? Or are all users trying to run the same copy from a network location? Users should have their own copy of the FE installed directly on their local drive, and that's what they run.

Each of those FE copies should be connected to the same BE, which must be located on a network resource with the correct permissions set on the Folder. Those permissions would be at least Modify on the Folder, with at least read/update on the file. Best to just provide Full permissions to insure everything is okay at first, then pare them down as needed.
DatabaseDekAuthor Commented:
Thank you.

I must say that I sometimes don't use Experts Exchange for months on end, but when I do, oh boy, do I get my money's worth!
DatabaseDekAuthor Commented:
I did not realise that points need to be added when a designated professional answered question.

My apologies for the delay.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now