Posted on 2014-08-13
Last Modified: 2014-08-13
Hi All Experts
Does anyone know whether having more back-ends with fewer tables performs slower/faster than say one BIG backend with all tables.

I have a number of systems with approximately 10 front-ends (for different departments/functionality etc) and 10 back-ends and always wondered if 'consolidating' the BEs would increase/decrease performance?

The multiple BE systems seem to perform OK; although they require periodic c&r (usually every 3-6 months )

Ideally this question would be answered by someone who has had similar installations over many years (or is involved in MS Access JET/ACE design and drivers)

Question by:COACHMAN99
    LVL 75

    Accepted Solution

    There is always the potential of more users in the same BE (ie consolidating) having a negative impact on performance.  If each of your 10 FE are connected to their respective BE ... I would leave it alone, unless you have some overwhelming reason for consolidating, possible for reporting purposes, etc.

    I currently have 45 FEs connnected 45 BEs, with anywhere from 3 to 120 users in a given db. Where as I could ... do some consolidation (and I may for very similar db functions), at this time I am not making any changes.

    LVL 7

    Author Closing Comment

    Excellent thanks; that corresponds with my observations. (if it aint broke ... :-))
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    I agree with Joe...I'd keep them separate.   There is some consolidation of resources if a user uses more than one of the applications at one time, but if their going against one BE all the time, then forget about it.


    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    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…

    729 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

    20 Experts available now in Live!

    Get 1:1 Help Now