Having the code is by far the least of the problems. The capability that was there was extremely basic and could be replicated easily. I have been trying to understand the data, but without any relationships or queries it is pretty tough. I took a shot at that to see how far back you would have to peal the onion, but the amount of time would be significant. I focused on trying to fix the tables and get some of the key forms working.
The original developer did not seem to understand how to make queries, use comboxes, but had a small idea on normalization. There are foreign keys, but often the primary key is an auto iD that is not used anywhere. Fixing any code would be a bandaid on a gaping wound. Here is my shot at fixing some of the tables. The biggest was moving the hundreds of separate Cable tables into one table. However, the more I dug I see that there appears to be far more non normalized tables, and there needs to be more redesign.
