1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Speeding up an Acces Database

Discussion in 'MS Access' started by pbrydone, Mar 23, 2010.

  1. pbrydone

    pbrydone New Member

    Joined:
    Mar 23, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    I have created an MS Access database primarily for tracking file movement. The database is a split database and has a front end which sits on client computers (about 10 computers) and a back end which sits on a Server 2003 server. The problem I am having is that the database runs too slow even with no more than 2 concurrent users. I have checked our etwork and can't spot any issues that culd slow things down. On a standalone non-split database it appears to run quite ok. The tracking number is scanned in via a bar code scanner and other fields are manually entered.

    Grateful for advice on how I can speed things up and also if anyone has some ideas on how to generate a search form.

    I have attached a non-split database in zipped fomat

    Many thanks
     

    Attached Files:

  2. apr pillai

    apr pillai New Member

    Joined:
    Dec 17, 2010
    Messages:
    16
    Likes Received:
    12
    Trophy Points:
    0
    Occupation:
    Auditor
    Location:
    India
    Home Page:
    Run Repairing/Compacting untility at least once in a week.

    Take a Backup of the database before you run the above utility.

    You must have exclusive access and Administrative privilages to run the Repairing/Compacting utility.
     
  3. apr pillai

    apr pillai New Member

    Joined:
    Dec 17, 2010
    Messages:
    16
    Likes Received:
    12
    Trophy Points:
    0
    Occupation:
    Auditor
    Location:
    India
    Home Page:
    Access2007:

    Click the Microsoft Office Button [​IMG], point to Manage, and then, under Manage this database, click Compact and Repair Database

    In older versions you can find this option under Tools Menu.
     

Share This Page