Mike Swanson
9a2a05e3cb
Drive 3 yielded the biggest finds in the project so far.
VHDX mount + scan (D:\WIN7-Orders\Darv-2\VWP1.VHDX, 117 GB Hyper-V disk):
- Mounted read-only as F:, scanned in 85s, dismounted
- NOT Darv's dev box - it's the office "owner" admin workstation
- No newer source code found inside, but:
- Vwp11.mdb (2023-07-27, 369 MB) - NEWEST DB snapshot anywhere
- Vwp.mdb (2022-12-23, 769 MB) - on Desktop\Darv VWP
- Orders Versions/ desktop folder with 2 EXEs + 7 shortcuts
- The .lnk shortcuts all pointed to G:\VWP2\Orders*.exe - the
"Aha!" that revealed where Darv's iteration happened
- Saved to source-code/from-VHDX-VWP1/
The VWP2 grab (D:\97-Server-G-Drive\g$ 2024-04-10\VWP2\):
- This is Darv's actual iteration workspace on the production
Orders server (G: drive)
- 16.36 GB total, 1,061 files. Grabbed 886 files (~893 MB) filtered to
*.exe, *.rpt, *.ocx, and VB6 source extensions:
- 64 Orders*.exe versions - complete iteration history (includes the
production Orders_10A.exe + Orders_10Z.exe variant + dozens more
with Darv's "iterate-and-rename" naming pattern)
- 820 Crystal Reports (.rpt)
- 2 .ocx supporting controls
- Skipped 23 historical .mdb backups (15.8 GB) - we already have
newer snapshots from 000_ASource and VHDX
- Skipped 6 large subfolders (HOLD, HHOLD, Pay_2021_0325, GWAC,
20220205, 20211010 RPT) - mostly more MDBs
- Saved to source-code/from-VWP2-97server/
What we learned about the 4-year gap:
- No source code newer than 2020-06-09 ORDERS_C.vbp baseline found
on any of the three rotation drives
- The 64 EXE versions in VWP2 go through 2022 - Darv was iterating
and rebuilding compiled output but not updating his .vbp source
control. This is consistent with his "rename and try" workflow
- The production exe (Orders_10A.exe) is in this batch - now we can
use VB Decompiler Pro on it without needing the original drive
Helper scripts:
- scan_vhdx.ps1 - fast PowerShell scan of a mounted VHDX for source/DB
- find_vwp2.py - cross-CSV search for the VWP2 path
- vwp2_summary.py - size+type breakdown of the VWP2 folder
- debug_vwp2.py - one-off debug helper
Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
100 lines
7.1 KiB
Markdown
100 lines
7.1 KiB
Markdown
# VWP Orders — Source Code Recovery from D: Backup Drive
|
|
|
|
**Recovered:** 2026-05-16
|
|
**Source drive:** D:\ (label `Backup`, 8 TB, 5.3 TB used) — one of several VWP backup drives in Mike's possession
|
|
**Provenance CSV:** `../WizTree_20260516172207.csv` (393 MB raw export, gitignored)
|
|
**Analysis CSVs:** `../source-analysis/D-drive-2026-05-16/` (per-category, per-keyword)
|
|
|
|
## What's in here
|
|
|
|
### `Full-Project/` — Darv's "Full" project tree
|
|
- **Source:** `D:\Office-Estimates\Darv\Full\Project\`
|
|
- **Filtered to extensions:** `.vbp .vbg .vbw .frm .frx .bas .cls .ctl .ctx .res .rpt .ini .cfg .sql .qry .txt .md .doc .docx .pdf`
|
|
- **Master copy** (most files, older snapshot)
|
|
- Latest `ORDERS_C.vbp` date: 2019-11-05
|
|
|
|
### `Kingston-Project/` — Darv's Kingston USB project tree
|
|
- **Source:** `D:\Office-Estimates\Darv\Kingston\Project\`
|
|
- **Filtered** (same extension list)
|
|
- **Newer** ORDERS_C.vbp (2020-06-09) but fewer files — likely his current working snapshot from the USB stick
|
|
- The "Kingston" naming refers to the Kingston-branded USB drive Darv used
|
|
|
|
### `Source/` — `Darv\Source\` wholesale
|
|
- **Source:** `D:\Office-Estimates\Darv\Source\` (555 MB, 169 files)
|
|
- Contains a `History\Package\` and `History\Package2\` (InstallShield packages?)
|
|
- Has older files dating back to 1997 (`C4dll1210.dll`), 2002-2012 various
|
|
- Likely a personal scratch / archive area, not the live source
|
|
|
|
### `SOURCE-HOLD/` — `Darv\SOURCE HOLD\` wholesale
|
|
- **Source:** `D:\Office-Estimates\Darv\SOURCE HOLD\` (2 files only, < 1 MB)
|
|
- Named "HOLD" suggests intentional snapshot
|
|
|
|
### `000_ASource/` — Darv's "active source" folder (from drive 2)
|
|
- **Source:** `D:\Office-Estimates\Darv\000_ASource\` (drive 2, label `Backup`, 12 TB)
|
|
- 12 files, ~768 MB (mostly the `Vwp.mdb` which is gitignored — only ~4 MB of source/config goes to git)
|
|
- **`TEST_VWP.vbp` dated 2021-08-16** — the only .vbp on either drive newer than the 2020-06-09 ORDERS_C.vbp baseline. Likely an experimental scaffold (only 810 bytes).
|
|
- **`frmLotInfo*.frm` variants** dated 2020-10 to 2021-08 — Darv was iterating on a form. The `JJ` and `Z` and `5JJ` and `5Z` suffixes are his variant-marker convention.
|
|
- **`Vwp.mdb` dated 2022-10-19** (764 MB) — newest database snapshot anywhere, two years more recent than what the prior session had. Gitignored; on local disk only. Useful for schema-evolution analysis.
|
|
- **`MSSCCPRJ.SCC` file** — Microsoft Source Code Control project file. Confirms Darv was using **Visual SourceSafe**. There may be a SourceSafe repository (`srcsafe.ini`) on a later drive that contains full version history. Worth grepping for `*.scc / srcsafe.ini` on subsequent scans.
|
|
|
|
### `from-VWP2-97server/` — Darv's iteration workspace (from drive 3)
|
|
- **Source:** `D:\97-Server-G-Drive\g$ 2024-04-10 21;13;45\VWP2\` (drive 3 snapshot of the production Orders server `G:` drive)
|
|
- **886 files, ~893 MB committed** — filtered to *.exe, *.rpt, *.ocx, plus VB6 source extensions (none found)
|
|
- **64 Orders\*.exe versions** — Darv's complete iteration history. Filenames follow his "iterate-and-rename" pattern: `Orders_10A.exe` (the production EXE), `Orders_10Z.exe`, `Orders22.exe`, `Orders24.exe`, `XXOrders_08.exe`, `XOrdersXX.exe`, etc. Spans 2021-2022+ build dates.
|
|
- **820 .rpt Crystal Reports** — current and historical report templates
|
|
- **Skipped:** 23 historical Vwp.mdb backups (~15.8 GB) and 6 subfolders (HOLD, HHOLD, Pay_2021_0325, GWAC, 20220205, 20211010 RPT — mostly more MDBs). We already have 2022-10, 2022-12, and 2023-07 MDB snapshots from other locations.
|
|
|
|
### `from-VHDX-VWP1/` — Office admin "owner" workstation (from drive 3, mounted VHDX)
|
|
- **Source:** `D:\WIN7-Orders\Darv-2\VWP1.VHDX` (117 GB Hyper-V disk, 2023-09-01)
|
|
- VHDX was mounted read-only as F: drive on 2026-05-16, scanned, then dismounted
|
|
- **NOT Darv's dev machine** — this is the "owner" user's accounting/admin workstation that used the Orders app
|
|
- **`Orders-Versions/`** — Desktop folder with 2 EXEs (Orders22.exe Nov 2021, Orders24.exe Mar 2022) and 7 `.lnk` shortcuts ALL pointing to `G:\VWP2\Orders*.exe` — confirms G:\VWP2\ on 97-Server was the live shared location
|
|
- **`database-snapshots/Vwp11_2023-07-27.mdb`** (369 MB, gitignored) — **newest DB snapshot anywhere** (9 months newer than 000_ASource's 2022-10 copy)
|
|
- **`database-snapshots/Vwp_2022-12-23_from-Desktop.mdb`** (769 MB, gitignored) — December 2022 snapshot
|
|
- **`misc/VWP1202Fix.zip` + `.log`** — undated fix package from 2017
|
|
|
|
### `VMs/` — VirtualBox disk images (gitignored)
|
|
- **`VWIN7-DW.vdi`** (8.3 GB) — Darv's actual Windows 7 Dev workstation
|
|
- Source: `D:\Office-Estimates\Darv\VirtualBox\VWIN7 DW.vdi`
|
|
- Boot this to get his full dev environment with VB6 IDE, paths, dependencies intact
|
|
- **`XP-for-ORDERS_copy.vdi`** (2.8 GB) — XP runtime for compiled Orders
|
|
- Source: `D:\Office-Estimates\Darv\VM_VDI\XP for ORDERS_copy.vdi`
|
|
- Useful for runtime testing of the compiled Orders_10A.exe
|
|
|
|
## Three VB6 project variants identified
|
|
|
|
| Project | Purpose | Latest .vbp | Location pattern |
|
|
|---|---|---|---|
|
|
| `ORDERS_C.vbp` | Main Orders application | 2020-06-09 (Kingston) | `Project\VWP_Current\` |
|
|
| `ORDERS_Cx.vbp` | Variant (possibly experimental) | 2018-12-11 | `Project\VWP_Current\` |
|
|
| `ORDERS_I.vbp` | Invoicing module | 2019-03-21 | `Project\VWP_Inv\` |
|
|
|
|
Also `VWP_Current_0317/` and `VWP_Update/` folders exist — likely interim dev branches.
|
|
|
|
## What was intentionally NOT copied
|
|
|
|
| Class | Why skipped |
|
|
|---|---|
|
|
| `Recovery\Darv\` (78 GB) | Older copy of master Darv folder — same source, older snapshots |
|
|
| `Estimating Archive 2024-04-23 01;46;22\Darv\` (135 GB) | Bit-for-bit duplicate of master Darv per WizTree size/file count |
|
|
| 635 `.mdb` Access DB backups (195 GB total) | Live `VWP.mdb` already in `source-analysis/`; historical schema snapshots can be revisited on demand |
|
|
| 14 OVA exports of VMs (58 GB) | Largely duplicates of the two VDIs we grabbed; OVAs are portable but less efficient for running |
|
|
| `Darv\Full\Program Files\` (large) | Darv's installed dev tools — the VWIN7-DW.vdi already contains his complete installed environment |
|
|
| `Darv\HD2 Info\Darv\` (6.25 GB) | Secondary HD info, lower priority |
|
|
| `97-Server-G-Drive\Users\Darv\` (7 GB) | Older server snapshot, superseded by Office-Estimates\Darv\ |
|
|
| `VWP-ADSVR\Users\Darv\` (24 GB) | AD server profile — the live copy (with the lone `frmPayroll.frm`) was already analyzed in 2026-04-27 session |
|
|
|
|
## Open question — the 4-year gap
|
|
|
|
Latest `.vbp` modification on D:\ is **2020-06-09**. The production `Orders_10A.exe` was live in April 2024. Either:
|
|
1. Darv stopped maintaining source after 2020 and made later changes some other way (unlikely)
|
|
2. **Newer source exists on other backup drives** — re-run this scan on the next drives Mike connects, filter for `.vbp` mtime > 2020-06-09
|
|
3. The 2020 source IS substantially the production code — minor or no functional changes since
|
|
|
|
Once additional WizTree CSVs are dropped in `source-analysis/`, re-run `analyze_wiztree.py <csv> <out>` to cross-reference.
|
|
|
|
## Tools
|
|
|
|
- `../source-analysis/analyze_wiztree.py` — re-runnable WizTree CSV analyzer
|
|
- `../source-analysis/size_candidates.py` — folder-size triage script
|