The person who designed the program is gone. I know that story. The various programs were in either dBase IV or dBase V. Management task tracking and scheduling, shop orders and procurement stuff. Reports quit working, forms showed no data, no one wanted or knew how to fix it. I didn't want to fix it I wanted to replace it. Give me the data, all of it, look quickly at the rest of the crap and then trash it. Import and clean up the data (with SQL) and start all over with queries, forms and reports. It is so nice to have everything in one file and not a whole directory full of crap.
You see the craziest things, dates that are not dates because they have TBD, ASAP, N/A, 06/03E (for estimate) and A (for actual). Actually what? Actually wrong! What year was that?
Will keep you awake at work! Roy
|