IMPORTANT: Change setting in Access Program
You must have Access 2010 installed on your system. (Access 2000, 2003, and 2007 probably still work,
but I cannot guarantee future backward compatibility.)
All versions of Access need to have Action Queries Unchecked, Access 2010 needs to allow macros.
See the attached document for complete instructions.
Access 2010 Settings
(Access 2007 Settings)
The Menu System in Version 17 has been radically redesigned, as well as a cleanup of obsolete programs. Review the two documents to aid in the
Occasionally there are changes by National, or errors discovered in the Access programs. If you wish to be notified, please enter your email address.
(This must be repeated for every new release).
Load the Version 17.0 Data file first. (This action will overwrite any previously entered data.)
|Version 17.0 Data
|This is an executable file named (data.exe). It should create the capwatch directory and the
downloads directory as well as loading the data databases, two font files and a sample signature image. Clicking on Version 17.0 Data should
prompt you to save the file. Save it to your desktop and then click on it. It should extract 11 files. (You can delete this file from
your desktop after it has successfully loaded the data to c:\capwatch.)
This file contains several databases that
hold different kinds of data:
- data.mdb - Basic setup and participant data
- finance.mdb - Financial data - Payments
- disbursements.mdb - Disbursements
- flights.mdb - Orientation & Military Flight Set up files
- Medical.mdb - Medical Information
- history.mdb - last year's history - will be blank in this download
- SSN.mdb - previously collected Social Security Numbers - will be blank in this download
- travel.mdb - travel information and guests
|Version 17.0 Programs
|This file contains the Encampment Management programs. This is an executable file named
encampment.exe. Save it to your desktop and then click on it. (You can delete this file from
your desktop after it has successfully loaded the Encampment (2017) 17_0.mdb to c:\capwatch.)
- Encampment (2017) 17_0.mdb - Database that holds all programming
|Empty Capwatch Database
|This file contains the capwatch database from National HQ. (This includes the file change made in May 2016). In order for the
programs to work properly you need to have this database located in the C:capwatch directory.
If you download your wing data from
National the interface programs in the Encampment Management Program will load the National data into these files. Clicking on Empty
Capwatch Database should prompt you to save the file. (The executable file is named capwatch.exe.) Save it to your desktop and then click on it. It should extract 1 file -
capwatch.mdb and locate it in the c:capwatch directory. (You can delete the saved file on the desktop after it has successfully loaded the file.)
- capwatch.mdb - Database that holds downloaded data from National.
|| To maximize the use of these programs, the CAPWATCH files for your wing should be downloaded and stored in
the C:capwatch\downloads directory. The link (National CAPWATCH) will take you to the sign on screen for the National Web Site
for Civil Air Patrol. You may need to register and/or get authorization from your wing to do this
download. Click on the link Directions for CAPWATCH Download for
full instructions on how to complete this process. (After Downloading data from National, you need to run an additional program in the Encampment
[Back to the top]
Final Installation Tasks
[Back to the top]
Verify that the following files exist in the directory c:capwatch.
Nottingham (Notting.ttf) and Casque Open Face (Casqueof.ttf) are two fonts that have been used to
create an elegant Certificate of Appreciation and Certificate of Accomplishment. These two fonts are included with the
database. Install the fonts (Control Panel, Fonts, Install). If you do not install the fonts, your
computer should still print these forms with the closest font available.
The programs as installed will not print a signature on Certificates of Accomplishment. If you want this
feature follow the instructions on the "What's New File - User
Download the latest CAPWATCH. (Make sure that the files are extracted to the
downloads directory (C:\CAPWATCH\downloads)
If you have History from last year, replace the History Database.
If you have Social Security Numbers from last year, replace the SSN Database.
- You can make a shortcut to Encampment (2017) 17_0.mdb to more easily initiate the Encampment Management Program