Currently I am building front-end applications in MS Access that retrieves and manipulates data through ODBC to SQL Server 2000. The only reason I am using MS Access is because this is the only software they had when I started. I have had successful experience with Visual Basic 6.0, but I do not know if this is the right direction for our company. I will be tasked to build Windows applications as well as interactive Web applications. My question is should I purchase VB 6 with Crystal Reports 10 or VB.Net with Crystal Reports 10. I have never had to purchase or investigate what software to use, I have always worked for companys that said this is what you will use. My current organization didn't even have a SQL Server before I started. I need your opinon, websites that offer the pros and cons, or any alternatives that would meet the needs of our organziation. Additionally, with the web based application should I purchase dream weaver, front page, or can all web development be accomplished using VB.NET. What is the best reporting program to use. I know that I am asking a great deal, but I figured you guys are the experts and am sure you have had more experience with the combinations of software that I am looking into.
Some of our plans for the Windows applications will be used primarily in-house, with a few (1-5) users accessing the program over VPN.
Thanks in advance for all your suggestions.
Our company is growing rapidly and the types of programs I am being asked to build range from simple to impossible (*lol*).