================================================================================
              NAVFIT98A v33 PATCH 2 DATABASE CONVERSION UTILITY (v2.0)
                           OPERATIONAL USER GUIDE
================================================================================

1. PURPOSE & OVERVIEW
--------------------------------------------------------------------------------
This standalone conversion tool updates NAVFIT98A database files Prior to 
Version 33 Patch 2 (.accde) to full schema compatibility with NAVFIT98A 
Version 33 Patch 2. This replaces the previously released Database Conversion
Utility tool.

It safely creates a copy of your database with all newly required data fields 
while leaving your original database file untouched as a permanent backup.  

NO CODE CHANGES OR INSTALLERS ARE REQUIRED. Does not need admin privileges to run.
This is an Microsoft Access Database file and not an executable.

2. Security Requirements
--------------------------------------------------------------------------------
in some systems/networks, the Access Database Micros are disabled which does not allow 
this tool to run even though it is a compiled application that does not allow users
to change the source code.  If this software is blocked, you will have to request a 
Group Policy (GPO) Exception. Contact your IT Administrator or Helpdesk with the 
following request:
	"I am running a compiled database application 
	(NAVFIT98A_v33p2_Upgrade_Tool.accde) on my computer.  Group Policy
	is currently blocking the VBA startup cod from executing. Could you
	please configure a Trusted Application exemption via Group Policy so 
	that my local MS Access application is permitted to run?"

3. SYSTEM REQUIREMENTS & PREREQUISITES
--------------------------------------------------------------------------------
- Operating System: Windows 10 / 11 (NMCI / Flank Speed / Enterprise Seats)
- Software: Microsoft Access (Access 2016, 2019, or Microsoft Office 365 Apps)
- Compatibility: NAVFIT98A Version 30 through 33 to NAVFIT98A Version 33 Patch 2
- May need to get Access Macros allowed through your IT department

Step 1: RUN THE CONVERSION TOOL
  - Double click the NAVFIT98A_v33p2_Database_Conversion_Tool file to run the tool
 
STEP 2: SELECT YOUR SOURCE FILE
  - For the "Input NAVFIT98A Database (.accdb file))" field, click [Browse...] and navigate to 
    your existing NAVFIT98A database file - any database file used in v30 through v33
  - For the "v33 Patch 2 Database Destination and Filename" field, the tool will 
    automatically suggest a filename ending in "_v33p2.accdb". 

STEP 3: (OPTIONAL) SELECT YOUR DESTINATION FILE
  - If you want a different filename or destination than what was suggested, click the 
    [Save As...] button to choose your target location and preferred file name... 
    NOTE: the new file can be in the same directory as the source file, but DO NOT 
          name the new file the same as the old file if both are going to be in 
          the same file location.

STEP 4: EXECUTE CONVERSION
  - Click the [Convert Database] button.
  - Review the confirmation prompt and click [Yes] to proceed.
  - When the process completes, a pop-up window will confirm: 
    "Migration Successful!"

STEP 5: EXIT CONVERSION TOOL
  - Click the [Exit] button.

STEP 6: Launch NAVFIT98A v33 PATCH 2
  - Launch NAVFIT98A v33 Patch 2.

STEP 7: PICK METHOD TO USE
    OPTION A: 
  	- Go to File -> Open Database and select the newly converted database file.
    OPTION B:
	- Go to File -> Open Databases and select the database you are currently using
	- Click on or Create a Folder to Import the data into
	- Click on the [Import Data] button and select the newly converted database file 
	- Select the report(s) to import 
	- Click on the [Import] button

5. SECURITY & FILE INTEGRITY VERIFICATION (OPTIONAL)
--------------------------------------------------------------------------------
To verify that this tool has not been corrupted or altered in transit:

1. Open Windows PowerShell.

2. Run the following command (substitute with your file path):
   Get-FileHash -Algorithm SHA256 .\NAVFIT98A_v33p2_Upgrade_Tool.accde

3. Compare the calculated hash with the authoritative checksum provided in 
   the included "checksum.txt" file.

