Yes, maybe you do, but unfortunately it's not just a recompile and relink under new tools, and the Amazing Charts codebase is NOT small and is NOT simple. VB6 may indeed be 8 years old, but a migration to .Net is NOT trivial. A number of programming tools and 3rd party modules that Amazing Charts uses are not available in the .Net framework, and coding around this issue would also be major. This is not a trivial hack, unfortunately.
There are SQL databases available that don't have the issues that Lytec and other MS based SQL's have, which would be excellent for migrating AC to. There are also NON-SQL databases that would also be excellent.
While I agree that migrating to SQL server under VB6 is "asking for trouble", my experience has been migrating to SQL server without VB6 can also be asking for trouble.
Heck, if it were up to me, I'd pick MySQL. :-) Still, ask any 5 software design engineers a technical question, get 20 answers. My only criteria for whatever Jon decides is that it has to be ROCK SOLID. My PREFERENCE would be that it not break too much of the existing code base getting there.
An IP addressable database would indeed to the trick - I'd love to be in a secure, client-server environment with secure transaction processing on both our in-house network and externally though our gateway. Still, the thought of being locked in to Microsoft's database makes me nervous, based on experience with other products which use it.
BTW - where in AZ are you? My brother and sister live in Tucson, and I have been known to drift out there every couple of years or so.
Regards,
V.
