Solved

What are the typical signs of a slow server in Access

Posted on 2014-04-10
8
265 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
  • 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
 
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

920 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

17 Experts available now in Live!

Get 1:1 Help Now