Solved

Which Database and Front-end for Web-based application?

Posted on 2014-11-04
7
493 Views
Last Modified: 2014-11-04
Hi,

I have 200 Users who would like to work on a shared database simultaneously, along with a web-based application. Which is a good solution and why?

1) SQL Server with ASP.Net and C#
2) MS Access with ASP.Net and C#
3) SQL Server with Java, or, C#
4) SQL Server with other front-end
4) MS Access with other front-end

Thanks,

San.
0
Comment
Question by:sanjay-gandhi
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40421088
SQL Server is a more powerful program and an actual multi-user server while Access is a desktop office product which has had multi-user and 'web' features added to it.  If your users are already using Microsoft Office Pro and the application is appropriate, Access can be used as a front-end for SQL Server.
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 333 total points
ID: 40421093
for any new (web) developments: don't use MS Access as db back-end. It may be used for front-end, but simply is NOT a reliable server product.

the choice of the development language is more a "what your people know already", as they all allow you to implement "all you want", as in the end the browser has to show some HTML and using some client-side javascript to do some "actions"...
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 167 total points
ID: 40421217
200 Users - this means you can't have Access as the backend. It's doubtful if you could get more than 10. Therefore, you have to have SQL Server as the backend.

Front end: Whatever is easiest for you BUT still gives you adequate security. For MS Access, you can have the front-end copied onto everyone's local machine, so that they are not accessing the front-end over the network, merely the data.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:sanjay-gandhi
ID: 40421234
The developers can be hired for the best technology. The decision by the (not-so-tech-savvy) on the top hierarchy has to be taken on what is the best solution, and that he does not take a wrong decision.

Therefore please answer which is the best solution among the points mentioned already in the previous question.

I understand from the answers above that SQL Server is good as the back-end database, and Access is out. Which front-end combination will be the best in that case.

San.
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 333 total points
ID: 40421238
> Which front-end combination will be the best in that case.
it does not matter. all (asp.net/c#, asp.net/vb.net , java, other...) will all be able to implement "any" requirements, as the development software will just build up the needed server side processing, generating html and client-side javascript.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40421259
Agreed.  Usually the technology your developers know is better than one they have to learn.
0
 

Author Closing Comment

by:sanjay-gandhi
ID: 40423094
Back-end
Access is not a good choice for Web database, because there are around 200 Users.
SQL Server would be a good option.
Front-end
ASP.Net with C# can the offing.

Thanks.

San.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

A Change in PHP Behavior with Session Write Short Circuit (http://php.net/manual/en/book.session.php#116217) (Winter 2014)** With the release of PHP 5.6 the session handler changed in a way that many think should be considered a bug.  See the note …
A publishing tool, a Version Control System, or a Collaboration Platform! These can be some of the defining words for the two very famous web-hosting Git repositories: Bitbucket and Github. Git is widely used amongst the programmers and developers f…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

679 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