This was probably wise and natural choice in that time (around 1997-2001), but if you consider Microsoft move to .Net platform and reshaping its own programming environments (ADO, OLE, VB, etc) – you would nowadays rather be nervous relying on VB 6.0 custom front end, calling stored procs via ADO.  Let’s consider your options:

• Upgrade to .Net.  As natural it might sound and look, however it might not be feasible.  The reason is - .Net is the whole revolution to Windows object model (or its introduction, somewhat more revolutionary, than J2EE/EJB/Java).  Your old VB code is not object oriented in the sense of .Net and majority of technologies are now obsolete or in phase out mode
• Move Front End to Web Application.  Or recreate simplified version as VB.Net or C#.Net web project.  If you think your stored procedures are still capable to do the job at the data manipulation level, you can redesign front end as web application.  This is preferred way for now, however as business owner you may not like the idea to redo it.
• Complications.  You might have additional complications, such as tiered design, when your presentation layer is
  

  Associated Websites

   

  Our Blogs are on UK small business and being a UK freelancer or contractor as well as website marketing and web design. If you are a biker we can help with your motor bike insurance.

   

  We have a site for contractors  and sites for HomeloansUK and PR-Help. We provide Branding help and offer Free-Marketing-Help and help for IT contractors. For E-commerce information, visit Small-Business-Web. We offer Page Rank Web Links and Cheap Home Loans Direct plus 0-BadDebtLoans and more Cheap Home Loans Direct. Our sites also help with Negotiation of any Personal-Secured-Loans. Our site called Management-Today can help you Innovate-Today, but for more loans go to 1st4HomeLoans.

   

  Our HomeLoansUK site is affiliated with Branding and TrafficBuilding sites and Sales technique site. Also on offer is Beauty-Online and FreeNetDesign. If you are a  contractor and need help with a Small-Business-Web then our E-Commerce site is great. If you want Easy-Mortgages or even 1st-4-Tenant-Loans go to 5-Star-Mortgages. We help find Cheap Kitchen Appliances and Low Rate Home Loans. For the IT contractor, EstuaryFinance can refer you to our Online IR35 Compliance site for help with IR35.

  
  separated from business layer (or physically these two layers sit on different computers).  Then, somebody should carefully analyze and design the upgrade path for both.  Unfortunately business logic level may deploy third party vendors logic, and these flourishing ISV of late 1990^th might be now out of business
• Integrations.  If your Great Plains is integrated with Unix, Oracle, DB 2, Lotus Domino, Siebel or other third party application – you need to consider synchronous upgrade for integrated applications to avoid retuning integration piece twice.
• Reporting.  Since version 6.0, Great Plains is very conservative to tables structure changes, so if your reporting was done in 1999 or later – more likely you are out of trouble and should use it as it is.

Happy customizing!  You can always appeal to us to help you with your system.  Give as a call 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com

ABOUT THE AUTHOR
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ( http://www.albaspectrum.com ), Microsoft Business Solutions Great Plains, Microsoft CRM, Navision, Microsoft RMS, Microsoft Business Portal customization company, serving clients in Chicago, Boston, New York, Miami, Atlanta, Houston, Dallas, Denver, Los Angeles, San Francisco, San Diego, Seattle, Minneapolis, Phoenix, Toronto, Montreal, Brazil, Mexico, UK, Australia, Canada, UK, Europe, Russia an having small offices in multiple states and internationally.