?
Solved

ASP.NET Deveopment with MS Access Queries or hardcode?

Posted on 2011-05-10
2
Medium Priority
?
274 Views
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,

Rit
0
Comment
Question by:rito1
2 Comments
 
LVL 45

Accepted Solution

by:
AndyAinscow earned 2000 total points
ID: 35728055
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.
0
 
LVL 1

Author Closing Comment

by:rito1
ID: 35728399
Excellent thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

850 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