Access Front-End performance

I recently rolled out a new database with front-ends on everyone's desktop and the back-end up on the server. When the users click on the icon it takes about 5-8 seconds to load the database. I'm guessing it's because it has to connect up to the back-end up on the server. But when I copy a new version of the front-end to their computers with some tweaks it now takes like 15-20 seconds to load when they click the icon. But then after that it opens within 5-8 seconds going forward. Why would it take so long that first time when I loaded a new copy of the front-end on their desktops? What makes that any different than any other time they click on the icon?
LVL 1
Lawrence SalvucciInformation Technology ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Walter RitzelSenior Software EngineerCommented:
What comes to mind is one of 2 things:
1) You load certain values locally to the database and because of that, it takes longer the first load;
2) The first connection takes more time than the subsequent ones because maybe of some registering process.
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
That's what I was kinda thinking too. But is there a way to speed that up? What I don't get is why only when I replace the front-end it does this. Nothing has changed between the tables in the back-end that would make it load slower.
Walter RitzelSenior Software EngineerCommented:
For option number 1, the only way to speed up would be deliver to the client the local tables already filled.
For option 2, I dont think there is much to do.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Lawrence SalvucciInformation Technology ManagerAuthor Commented:
How do I do that for option 1?
Walter RitzelSenior Software EngineerCommented:
Sorry, but if you are asking this question, this means that you did not understood what I had explained as for option 1.
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
No I don't understand. You say to deliver to the client the local tables already filled. What local tables are you referring to? All the tables are in the back-end.
Walter RitzelSenior Software EngineerCommented:
Yes, that's what I've figured out because of your answer, although your previous answer did not indicate that (when you ask if there is way to speed up).
But anyway, this means that your problem is related to the connection itself... For some reason, the first connection of your front end on the database on the back-end takes more time. If this is not related to some code you did, this is purely network and maybe database drivers. Since we are talking on access here, there is no other options for database drivers, so this most probably is network related.

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
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
ok so bottom line it's the network connection? There is no new code in the new copies of the front-end. It was purely query changes so that couldn't affect the performance for the first time it's opened. I'll check the network connections.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Check your anti-virus to ...make sure the DB's are not being virus scanned.

I'd also add a stop to the app right at the beginning so you can pin-point if it's Access starting up slow or your application.

 As for your backend linking, are you using a mapped drive letter or UNC?  Try switching that.  

Jim.
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
Hi Jim,

I'm using UNC mapping since not everyone has mapped drives to the server location. I'm assuming UNC is better?

Can you explain the adding of a stop at the beginning of the app to tell whether it's access or the DB?
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<I'm using UNC mapping since not everyone has mapped drives to the server location. I'm assuming UNC is better?>>

 Sometimes yes, sometimes no.   There are various things in the network which can cause issues.   Whenever you have a problem, it's best to see how both work and if one works better than the other, it pin-points an issue.

<<Can you explain the adding of a stop at the beginning of the app to tell whether it's access or the DB? >>

  in the applications code as soon as possible, put a STOP in the code, say in the onopen event of the startup form.

  Execute the app and note the time it takes to get to the STOP.  From there, you can hit F5 for it to continue and time how long the rest of the start-up takes.

  This will give you an idea if start-up delays are related to Access and getting the application open, or to things your application is doing.  You should also compare that to just Access itself opening (no DB) as well.

 Between the three times, you can then figure out where your slowdown is and what might be the cause.

Jim.
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.