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???

Derek BrownMDAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Derek BrownMDAuthor 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!
Derek BrownMDAuthor Commented:
I did not realise that points need to be added when a designated professional answered question.

My apologies for the delay.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.