Summary: Tip of the Week --- Running Repair and Compact
Author: CPS - Central Processing System (CPS)
THE MESSAGE BELOW REPLACES THE PREVIOUS MESSAGE THAT WAS SENT OUT ON FRIDAY (MAY 29).
TO: All Destination Points
FROM: CPS Customer Service
RE: Tip of the Week --- Running Repair and Compact
This week's tip highlights a specific feature or process in the EDExpress and
Pell Payment for Windows software: Running Repair and Compact. This is the
first in a three-part series of tips on maintaining optimum database and PC
performance. Following the processes outlined in these messages will improve
your processing speed. The second tip will cover the Scandisk utility, and the
third tip will address clearing your temporary file directory.
The repair and compact utilities should be run regularly on your EDExpress and
Pell Payment for Windows databases to maintain data integrity, to "clean up"
unused records, and in many cases to resolve database errors. Repair and
compact can be run from inside the EDExpress or Pell Payment software (via
Tools/Utilities). However, we recommend running these utilities outside the
respective software (EDExpress or Pell Payment) as described below.
All users must be logged out of the EDExpress or Pell database you plan to
repair and compact for the utilities to run successfully from Windows. You
should also ensure you have a reliable backup prior to running these utilities.
To run repair and compact from your Windows 95/NT PC, go to Start/Run, enter
ODBCADM, and click on enter. For Windows 3.X users, go to File/Run in your
Program Manager, enter ODBCADM and click enter.
In both cases, this will bring up a list of "Data Sources." You will need to
double-click here on the program and database you wish to repair and compact.
For example EDExpress 1998-99 is listed as "Express9"; Pell Payment for Windows
1997-98 appears as "Winpel78." These data source names will be followed by the
description "(Microsoft Access Driver [*.mdb])".
On the following screen, labeled "ODBC Microsoft Access 2.0 Setup," click on the
Repair button and verify the directory location of your EDExpress or Pell
Payment database. The 1998-99 EDExpress database file name is EXPRESS9.MDB, and
the 1997-98 Pell Payment database file name is WINPEL78.MDB. You may need to
search your hard drive or network for the correct database. Once you have
located the database, click OK and allow the repair process to run.
When the repair utility has completed, click on the Compact button and again
verify the correct database location before clicking OK. You should select the
same *.MDB file for "Database to Compact From" and "Database to Compact Into,"
and say yes to the "File Already Exists --- Overwrite?" prompt.
After repair and compact have completed successfully, you can resume using the
software and database you just repaired and compacted. We recommend you perform
these utilities on a weekly basis to maintain a high level of integrity.
If you have any questions on the repair and compact utilities, please contact
CPS Customer Service at 1-800-330-5947, option 8, or via e-mail at CPS@NCS.COM.