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/help/overview18.html

Campground Master Home