Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    12

    Angry Unanswered: Speed issues after splitting DB

    BACKGROUND INFORMATION:

    When I first designed a small database for the small law firm that I work for, it started out being just a basic database for holding case information. It has grown to be a decently-sized database (at least for us) as users kept asking me to add features.

    We WERE having everyone use the database (which is located on our server) at the same time because not many people will be using it at once... at least that was the plan. Now that it's completed to everyone's satisfaction, more people are using it and we're running into problems with records being locked and such.

    So...

    PROBLEM:

    I decided to use the handy-dandy "Database Splitter" feature of Access and split it into a front- and back-end database.

    I am doing some testing with the FE/BE design before I switch it over to the users. However, I am finding the speed of the application to be a lot slower than if we were all to be on just ONE database.

    Access seems to pull forms, reports, and queries up slower than our current one-database configuration.

    Could anyone help explain how this might be? I would figure with each user having their own FE database on their desktop only going to the server to get the information (new Dell server w/Server SBE 2003) that things would run FASTER.

    Since I'm new to all of this (sort of), I'm sure I'm missing something. I appreciate anyone's help!

    Sincerely,
    Tim

  2. #2
    Join Date
    Mar 2004
    Location
    Adelaide, Australia
    Posts
    32
    Have a look here for some tips on improving database performance.

    http://www.granite.ab.ca/access/performancefaq.htm

    HTH.

  3. #3
    Join Date
    Apr 2002
    Location
    Illinois
    Posts
    133

    Re: Speed issues after splitting DB

    Search the forum also. I found a couple of posts with good tips and links to articles.
    SteveH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •