On Thu, Feb 25, 2010 at 4:29 AM, Grant Molloy <[email protected]> wrote:
> Hi List, > > Does anyone know of, or even better could recommend, an application that > allows end users to build online web forms which save the data into a > database, allow adhoc query creation, maybe allow for data import and > export, maybe some user security too... > Preferably it would create ASPX pages and talk to SQL Server as this is > currently our preferred solution. > > My current client is using AchieveForms - http://www.firmstep.com/achieveforms.html. It seems to work well and non-technical end-users can create simple forms. If you want to pull data from LDAP / Active Directory, database, web service, etc. obviously some technical ability is required to set up the "data source". It can email form submissions and also create the back-end database tables required to save the form if need be. Forms can be anonymous or authenticated - recognising the current user and pre-populating form details with data from AD, etc. I've not used it to create forms myself, however, I have used it as an end-user to complete forms. Check out their fact sheet and/or demo. On the down side, they appear to be a bit of a tin pot outfit based on a system I've been asked to look at for performance problems (for which the reason is obvious to anyone with a clue about relational databases, XML and web services). YMMV. I'm asking because we're looking to get rid of all the MS Access databases > that users in departments make around the place.. > So in trying to take MS Access away from them I was after a tool which > would provide similar functionality, but put all the data in a central > database for security reasons. > The software should do this well. I have no idea of the cost. -- Richard Carde
