Best way to build web pages on IIS Server 7 with Access backend

Posted on 2011-10-31
Last Modified: 2012-05-12

I am an decveloper. I have been given the task of building a web site that manipulates the queries and tables of an Access database sitting on the sever. My initial direction was to just use a Web application project. Is this even the correct way to go?
Is there a better wat?

Question by:murbro
    LVL 74

    Accepted Solution

    There is no "Right" or "Wrong" way...

    Use whatever platform suits your needs...

    Just note that when you say "Web Page" and "MS Access Back end", that you will be limited by the same constrains that you have on the desktop.
    2GB size limit
    Limited "Concurrency"
    Minimal security.

    Also note that a lot of platforms will not recognize many of the "Access only" datatypes
    (Hyperlinks, OLE, Lookup, Multivalue, ...etc)

    Author Comment

    Thanks. My client uses Access extensively and they want users to be able to enter data and drill down to data via webpages
    LVL 83

    Assisted Solution

    >they want users to be able to enter data and drill down to data via webpages

    Webpages translates to ASP.NET given that you are programmer. You can go the MVC root but I would recommend webforms.

    Author Closing Comment

    thanks very much

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
    Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    729 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

    18 Experts available now in Live!

    Get 1:1 Help Now