ASP.NET Deveopment with MS Access Queries or hardcode?

Posted on 2011-05-10
Last Modified: 2012-05-11
Hi All,

Now if I had a SQL Server database I would naturally build a bunch of stored procedures to process my data requirements as I believe there is a performance benefit.

As I have to use MS Access on this particular project, is there any real benefit executing MS Access Queries rather than storing thehardcoded SQL statements within my data access layer classes?

Many thanks,

Question by:rito1
    LVL 43

    Accepted Solution

    Performance - as far as I know there will be no advantage (or disadvantage) to using Access queries.

    Design - the query designer in Access is very comfortable to use (I prefer it to SQL Server's design window) and being able to see a visual map of the query it is easier to understand than a lot of text.
    LVL 1

    Author Closing Comment

    Excellent thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    759 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

    9 Experts available now in Live!

    Get 1:1 Help Now