PIMS Resource Center

Improving PIMS Performance
Last updated 25 June 2013 RR

The following procedures may help improve the performance of PIMS.

Tips for Improving Performance on Client Computers

  • If PIMS is stored on a network drive, use a UNC path when linking to PIMS:
    • Go to the PIMS Main Menu
    • Click Select PIMS File
    • Click Link to Existing Database
    • Click Link to Existing Database
    • In the Select Database dialogue, rather than browsing to the pimstab.mdb file, enter the full path name in the File Name box and click Open.
  • Run an older version of Microsoft Access (preferably 2003 or XP). PIMS does not depend on features of newer versions of Access.
  • Replace the pims.mde file with a fresh copy (or re-install PIMS using the installer), then restore the link to the back-end using the Select PIMS File function.  This will effectively repair the front-end database.
  • Add RAM to your computer.  This is generally one of the easiest ways to improve system performance, though you should try this on one computer first to get a sense of how much this will help.  To check how much RAM your computer has, right-click on My Computer, and select Properties.  The System Properties window will open up.  Make sure the General Tab is selected.  Near the bottom of the window, you should see an indication of the amount of RAM installed in your computer.
  • Delete unnecessary files and empty the Recycle Bin
  • Defragment your hard disk with the Microsoft Windows Disk Defragmenter.
  • Disable any screen savers or use a blank screen saver

Repairing the Data Table

As you work with your database over time, your data file can become fragmented and use disk space inefficiently.  Also, it is possible that a database becomes damaged and starts to behave unpredictably.  PIMS has a database repair function that optimizes performance and repairs problems.  To do this:

  1. From the PIMS Start Menu, click Database Administration
  2. In the Database Administration window, click Repair Now.  This will make a backup copy of your database (e.g. “pimstab5_bkp.mdb”) and repair your existing database.  You may notice that as you do this, the size of your file becomes smaller.

You can also schedule repairs by setting the Schedule Repair button on.  You can then specify an interval in # of days.  When a user with admin rights logs into PIMS using the same front-end database after the date indicated in the Next Repair, that user will be prompted to repair the database or skip until the next scheduled repair.

  © Copyright 2007-2019 Prevent Child Abuse America. All rights reserved.