Web enabling MS Access Application...

I have an MS Access database that is being used at one company but I would like to market test the viability with different companies. Can anyone help me understand what is involved in Web enabling the application? I would like to do this economically as it is a test case and am wondering if it might be possible to simply add a front end or will it involve a complete redesign in a new platform? If and when we are ready to consider a larger roll out, what platform should I consider and what issues should I be mindful of. Thanks for any assistance.Few points come to mind while thinking about this project. First of all, when you say MS Access Application, I assume you mean Access Forms which are pretty much Windows-based. If so, then you are basically talking about rewriting the functionalities of Thick-Client (Windows application) to that of Thin-Client (Web application). It all depends on the features, but it's not going to be easy unless you are intimately familiar with developments in both environment. Web applications tend to be less robust in terms of UI, so any features like scrolling grids and other responsive UI's will have to be rethought and redesigned. Although you can ultimately incorporate AJAX features to add bells and whistles, but it just won't be the same as local Windows applications. Second thing to consider is that you should really abandon MS Access and go with Sql Server or other more robust DB technologies. MS Access is an entry-level DB that works well locally, but once you start dealing with applications that must cater to larger user-base and data-integrity, then it's not a good choice. The good news here is that it's relatively painless to move your MS Access schema to Sql Server. One immediate benefit you'll gain from using Sql Server is the pure raw speed. Also, you should consider using Stored Procedures to off-load the task of performing queries to the DB server itself. This offers better performance as well as better security, and is the preferred method when dealing with n-tier design.

Good luck.