Solved

What are the typical signs of a slow server in Access

Posted on 2014-04-10
8
258 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
A few details will help.
1. do you have a split database (or a single file)?
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:DatabaseDek
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you!

Derek
0
 
LVL 7

Expert Comment

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

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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…
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…

763 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

8 Experts available now in Live!

Get 1:1 Help Now