Access Database slow when put on Network

Hi all I have a Access 2007 database split Front End and Back end with a few a handfull of users which runs slow when Back end hosted on a LAN.  Im pretty sure it's a result of the LAN being heavily used.  It takes over a minute just to open.  The Front End has a main form that auto opens when at the start and has a handfull of subforms that have modules driving them using Form_Current().  Does Access check everything on load to see if all the connections are in place?  And is there anything I can do to speed things up?
 
PS.  SQL Server not an option.
JSSeniorAsked:
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.

danishaniCommented:
You may check the Performance FAQ by Tony to see and check for tips on how to improve your performance:
http://www.granite.ab.ca/access/performancefaq.htm

Check also this similar thread out for tips:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/518a3711-41fa-4f31-a423-9755e07d8840

Hope his helps,
Daniel
0

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
plummetCommented:
Hi

I've had this a few times, it's a real nuisance. Is your front end on the LAN or on local drives? In my experience moving the FE locally (I usually copy it from the LAN and open it from the C: drive via a batch file) is usually OK, even with the BE still on the LAN as it would have to be.

Regards
John
0
JSSeniorAuthor Commented:
Yes it is in a local drive.  What do you mean by batch file?
0
plummetCommented:
A batch file is a small program file that allows you to run commands, so in this case you can write one to do the following:

- Copy the FE file from a network location to a location on drive C:
- Start the FE from C:

The user would (typically) double click an icon on the desktop to do this, and it would be transparent to them. However if your FE is already on a local drive then it sounds like a network performance issue - you have to keep the BE on a shared drive so as long as all your forms, modules, queries etc are in the FE and the BE is just tables, there isn't much I can think of other than to move to SQL server, which is what usually ends up happening anyway as a database grows.
0
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.