Database - Web Based

Posted on 2011-10-05
Last Modified: 2012-05-12
I have a potential new customer that runs a non-profit organization that wants a web based database; it would be used to find and track donors, referrals, do some billing and follow up.  Right now, as I have been told, there are running multiple Access databases along with some Excel spreadsheets.  They want to do web based data entry accessible via the Intranet or Internet with Secure Login; ablility to make adjustments to the fields and they are open to any programming languages.  Although this is a minimum amount of information - is there anything anyone would recommend in order to do this?
Question by:Daren Anderson, MSIS
    LVL 74

    Accepted Solution

    This will be a "Huge" undertaking.
    Especially if you are new to database design and website design...

    The Access 2010 "Web Database" may not be up to the task (New technology, Macro based, limited security, ...etc)

    Most of the time when a "Web Based" solution is needed, it is usually advised to move the Backend to a SQL Server , .. and use a web development platform to build the interface:
    (.net, ...etc)

    But again, this will be a Huge undertaking, and the specifics will depend on many factors:
    Skill level
    Existing infrastructure

    So there is no clear solution, unless we are intimately familiar with all your business rules, requirements, constraints, ...etc


    Author Comment

    by:Daren Anderson, MSIS
    I do have many years experience using Access as well as many other higher end databases - SQL/Oracle; as well as a lot of experience in web design.  So I will agree this would be a huge undertaking for someone with less experience.  I probably should have not put this in the Access category.  Also, the details were very incomplete for anyone to make a educated guesstimate on it.  I am not sure on their budget but since it is a non-profit; I would think it is minimal.  Also, I am trying to find out there existing infrastructure - i.e. servers, SQL, etc.  I dont have that information as of yet.  I was thinking of looking at doing something in or something along those lines but with time constraints, I was wondering if anyone may recoomend something else with the very bad specs I have given.....
    LVL 119

    Assisted Solution

    by:Rey Obrero

    i would suggest using sql express ( it is free )


    Author Comment

    by:Daren Anderson, MSIS
    Yes I have used SQL Server Express in the past....good thought..
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)

     If the current setup does what they want, then you may consider simply putting the Access databases on the web with something like this:

    Another alternative is to run a terminal services server and have users remote in.

    However if there truly a need for a web based end user app then you have two choices:

    1. Use Access with Sharepoint - Expensive and as Jeff pointed out, may not be capable of doing everything you want.

    2. Re-write the apps with something like ASP.Net.

    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Thanks for the clarifications.

    We always have to mention the skills required, because many user (with limited experience) will presume that this will be easy
    (Just click the "Make web database" button)

    Then all my initial posts should still be valid.



    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now