Dan Waters
dwaters at usinternet.com
Sat Oct 17 09:40:39 CDT 2009
Hi Mark, What I'm working on is my system, modified for one of my customers. They are willing to pay me, but definitely not at the full amount it would be. So, my ROI is just getting up the learning curve of a new VB.Net developer. Since I've been programming Access for > 10 years, it definitely doable. Once my customer has a VB/SQL Server app, then it can be used by their sister companies as well, which leads to more work for me, and good stuff for them! Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Breen Sent: Friday, October 16, 2009 3:57 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access FE --> VB: Conversion/Rewrite Time? Hello Dan, The project I refer to was a VB6 project. For all intents and purposes though, it could have been an Access project. At the time there was a 'wizard' afair supplied by MS that converted VB6 to VS2003. It is this wizard that I refer to when I mention one hour. However, for all but the marketing dept in MS, the wizard was absolutely useless, and as we all know here, there is no comparison between VB6 and VS2003/5/8/10. In our case, the decision was taken to re-architect the application entirely, and to use a virtual team based on three continents, and to appoint senior manages on all three continents to be responsible and have an influence on the final outcome. Most people will not admit how much it really cost to redevelop, but it was enormous. Three or four years later, there is no additional business functionality. The project that I speak of reminds me so much of a book that Shamil mentioned here last April named "Dreaming in Code". That book is one that every programmer should be made read. And every customer also. [ Mark Simms asked Why ? What was the logic (if any) behind the decision ? Was this SQL Server with VB.NET <http://vb.net/> or ASP.NET<http://asp.net/> or ??? ] The original application was a VB6 app, the new app is a multi-threaded, multi-layer, system with multiple databases, windows services, web and winform, and as much OOP stuff as you can shake a stick at. And requirements from many people that then up-ed and left the company. I have to stop writing now as I feel my frustration rising :) In summary though, I would suggest upgrade if you wish, but do not let it take on a life of its own. What is your ROI ? Best of luck with it, Mark 2009/10/16 Dan Waters <dwaters at usinternet.com> > Hi Mark, > > Can you elaborate? What was it that would have taken just one hour? This > must have been a large access database to begin with. > > Thanks! > Dan > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto: > accessd-bounces at databaseadvisors.com] On Behalf Of Mark Breen > Sent: Friday, October 16, 2009 3:02 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access FE --> VB: Conversion/Rewrite Time? > > Hello Dan, > On one project I worked on, there was two options, > > 1) Convert - Cost about one hour > 2) re-write - Cost about €500,000 and it took ten people 18 months to > complete. > > They went with option 2. > > Mark > > > 2009/10/15 Dan Waters <dwaters at usinternet.com> > > > I know some of you have done this! Do you have any general rules of > thumb > > on how long the conversion or rewriting took you? > > > > Thanks! > > Dan > > > > > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com