Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

What are the typical signs of a slow server in Access

Posted on 2014-04-10
8
Medium Priority
?
277 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 2000 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

722 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