Database Maintenance

GLS provides some basic tools for maintaining and "backing up" the database. These include the Diagnostic Test, Deleting Leagues, Compacting the Database, Making a Backup Copy of the Database, and Installing the Backup Copy of the Database.

DIAGNOSTIC TEST: This test is available to check the database for obvious errors such as incorrect settings or missing records. For example, the test checks for Null values in the schedule. This feature may give you a clue when you suspect that something is "not right." The Diagnostic Test is located in the Edit Menu under Database.

DELETE LEAGUE or COURSE: ( Before deleting a league make sure you run and save any reports you wish to archive as spreadsheet files. Open the database table in read only mode and save to disc.)

To delete a League or Course and all its' associated records and tables, from the Edit Menu select "Edit Database." Select a League or Course to delete. Press Cancel to Quit with no effect on the database, or Press Delete to delete all League or Course files. Because the database will maintain "referential integrity," you may not be able to delete a Golf Course if one of the current leagues is played at the course. Only courses not being used by a current league can be deleted.

COMPACTING THE DATABASE: As you open, close, add, and delete records in the GLS database, the size of the database grows and can waste disk space. Compacting the database will organize the records and decrease the size of the actual database file. It is a good idea to periodically compact the database, say once a week, or once every two weeks. (there's no limit however) To compact the database select "Compact Database" from the File Menu. The database will automatically compact. You will be offered the opportunity to Back up the database before compacting begins.

BACKING UP THE DATABASE: It is recommended that a Backup Copy of the database be made before exiting GLS. This is easily accomplished by selecting "Backup Database" from the File Menu... Database Maintenance. GLS will place the database copy to a folder of your choice.  This same function can be performed from the Windows File Manager. Go to the GLS8 folder and click on the Database sub folder. Make a copy of the GLS80.MDB File. This is the main database file. You can use a tape backup or a "Zip" compression program to make the file fit on a diskette.

INSTALLING THE DATABASE BACKUP COPY: In the unlikely case that you have to install the backup copy of the database it can be done by selecting  "Install Backup" from the File Menu... Database Maintenance.