Database Maintenance Overview

Top  Previous  Next

The database maintenance functions are miscellaneous functions you can use occasionally to check the database for anomalies or make manual corrections. Database anomalies like bad links, orphaned transactions, etc. could occur as a result of internal program errors, accidental deletion of records through Raw Data Tables or Pick lists, database corruption due to a computer crash, or improperly restoring from a backup database.

Except for the balance adjustment functions, it's a good idea to run through these every few weeks just to make sure no problems are occurring that need to be corrected. The "orphan" functions and the bad-links function can correct the database automatically. Unmatched transfers need to be manually corrected.

Most of these functions require administrator access (at least to make any changes), but the Orphan and Unmatched Transfer reports can be viewed with Manager access so they can at least be monitored more readily.

Networking note: Since some of these functions require a large number of records to be locked and modified, it's recommended that you perform these only on the Master workstation.



Topics:

Deposit Balance Adjustment

A/R Balance Adjustment

Report and repair Orphaned Transactions

Report and repair Orphaned Reservations

Report Conflicting Reservations

Report Unmatched Transfers

Repair <bad links>

Show the current database location

Move the database to Shared or Public Documents

---

Page URL http://CampgroundMaster.com/shelp/overview18.html

Campground Master Home