I’ll try to get to the point quickly here. I appreciate any and all information I can get!
I manager a small team developing applications for internal business processes. The technology we are using is .adp (.ade for the executable). If you are not familiar this is forms/reports built in MS Access (in this case 2007) with all the data residing on SQL server. So basically a client-server architecture. We utilize some server-side technologies as well such as views, stored procedures etc. We’ve developed an extremely powerful and valuable application and are looking for an opportunity to start utilizing more “enterprise” grade technologies (i.e. Java, VB.NET, C#.NET etc.)
So a couple questions for the TechRepublic universe:
1. Do you know of any explicit limitations of .adp architecuture (explained above)? Or have any opinions as to what risks we run by continuing to grow our user base by sticking with this architecture? (Currently 35-40 concurrent users looking to expand to up to 80-100)
2. My main problem is that I have two developers who’s primary expertise is developing in this architecure, so I’m looking for opinions on a good Rapid Application Development architecture that would “feel” similar to the type of development done in MS Access front-end and/or a Visual Studio feel. Basically I’m trying to find a language that would be much more scaleable without “starting from scratch” from a learning curve perspective.
Thank you all very much!!
