I currently have a MS Access application that consists of the database and a fairly sophisticated UI for displaying and interacting with the database. This application needs to be re-written for the web. I plan to port the DB to SQL Server and I understand that most of my database code can be incorporated into the web based application. The problem I'm having is trying to decide what language/technology to develop the web app in. I have started learning ColdFusion which is really easy to use and has a nice DB interface. The problem I'm having is with the User Interface. I'm so used to event-driven UI development with rich components (grids, trees, etc.). I've been looking at developing the UI in Flash (Flash Forms) and using ColdFusion for the coding.
There seem to be so many options and I'm overwhelmed. I have access to ColdFusion so there are no purchasing requirements involved. I've been reading about JavaServer faces and the interface seems more rich and I am a novice Java programmer.
Can anyone recommend what technology to use? I don't have to interface to any existing technology so that's nice. Our company already has SQL Server and the ColdFusion server. I'd like the UI to look nice and resemble a stand-alone application UI. I don't particularly like the HTML Form look. Is Flash Forms a good choice? Any good book recommendations on developing Flash Forms? Should I be looking at something entirely different? Our company also has access to .Net. I realize that to a large degree it's a matter of preference but I'm looking for the best combination to develop a nice looking User Interface.