Solved

Access Database slow when put on Network

Posted on 2012-04-11
4
385 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

726 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