Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

What are the typical signs of a slow server in Access

Posted on 2014-04-10
8
Medium Priority
?
279 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

877 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