Solved

What are the typical signs of a slow server in Access

Posted on 2014-04-10
8
276 Views
Last Modified: 2014-04-11
I have an access application showing errors spontaneously. Such as; opening a form and no subform and no subform data is available. I think that some tables on the server are just not coming through at all or quickly enough. So the link does not seem to be made to the data or the link gets broken.

The client concerned tells me that at this time of year the accounts dept. run some data queries that over load the server causing other programs like sage to crash.

I have exactly the same access program working with other servers without any sign of a problem
0
Comment
Question by:DatabaseDek
[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
  • 5
  • 3
8 Comments
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 39992225
You didn't pose a question, but it sounds like you have the answer?
This is probably server not LAN. Assuming you have a front-end/back-end setup, can you not place the back-end on another machine?
0
 

Author Comment

by:DatabaseDek
ID: 39992300
Well I had assumed (always dangerous) that if a server was available that that was the best place for the data to go. Is that not the case? will it work better running from another PC?

Derek
0
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 39992357
Assuming you have a front-end database, and a back-end database (i.e. two Access files, not a single-file system) the back-end (or the only file) can reside on any machine.
Unless the application has only one user, the database is usually split into two files.
If there are multiple users on different workstations then the back-end should reside on a mapped drive, and a copy of the front-end should be on each workstation. The front-end (forms, queries,, reports etc.) should be linked to the back-end (tables and shared data).
If the 'server' is overloaded, and the LAN not, then another (accessible) machine can act as the 'server'. (remember to include the back-end in any back-up policies.
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 7

Expert Comment

by:COACHMAN99
ID: 39992434
A few details will help.
1. do you have a split database (or a single file)?
0
 

Author Comment

by:DatabaseDek
ID: 39993571
It is a split database. It is deployed as you suggest. I am simply shocked that another machine is as good a place for a file as a server for access data location. But as most workstations are under utilised I guess it is a logical step to stick the data on another PC.

So I guess that a server is more about security and backup than anything else?
0
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 500 total points
ID: 39994650
Security, reliability, backup, accessibility, and (usually) performance.
If the server is doing a processing job (like SQL Server or Exchange) then its performance is more important. As a file-server (MS Access), not so much.
If the chosen workstation is being used then probably not much gain, but an interesting experiment into where the performance is being lost (LAN vs server)
0
 

Author Closing Comment

by:DatabaseDek
ID: 39994672
Thank you!

Derek
0
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 39994680
I hope it works out - don't forget the backups :-)
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

630 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