Table of Contents

DPC is Behaving Oddly or Displaying Incorrect Values

Views: 778 Last Updated: 02/22/2018 01:26 pm	0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

Issue

You are experiencing one or more of these symptoms.

DPC is running very slow
Your Bid shows values that do not seem correct (maybe your % Complete for the job changes every time you look at the Bids Tab or you are seeing LCCs you know you've completed changing % complete values.
You are unable to send or receive DPC Changes

Resolution

These symptoms are often indicative of a database in need of some housekeeping. Luckily, DPC includes a function called "Compact and Repair" that does this for you.

To run a Compact and Repair on your database:

Close DPC
Reopen DPC but do not activate any Bid (do not click on the Image, Budget, Timecard, Payroll Recap, or Notes Tabs)
Click File > Open - the Open Databases dialog box opens
Highlight your working database (it will have a checkmark in the box next to it - if there are multiple, repeat this process, one-at-a-time, for each open database)
Click the "Compact and Repair" button at the bottom of the dialog box - if this is the first time you've done this and your database has been in use for more than a few weeks, this might take several minutes to complete

Note

It's a good idea to run a Compact and Repair on your database at least once a week. This keeps your database in tip-top shape and helps prevent errors. See the User Guide for more information on database maintenance.