Solved

Access Database slow when put on Network

Posted on 2012-04-11
4
337 Views
Last Modified: 2012-04-15
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.
0
Comment
Question by:JSSenior
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
danishani earned 500 total points
ID: 37835866
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
 
LVL 10

Expert Comment

by:plummet
ID: 37836512
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
 

Author Comment

by:JSSenior
ID: 37840272
Yes it is in a local drive.  What do you mean by batch file?
0
 
LVL 10

Expert Comment

by:plummet
ID: 37841930
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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now