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


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


Sanjay GandhiFounder, KenhalAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
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.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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"...
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Sanjay GandhiFounder, KenhalAuthor Commented:
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.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
> 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.
Dave BaldwinFixer of ProblemsCommented:
Agreed.  Usually the technology your developers know is better than one they have to learn.
Sanjay GandhiFounder, KenhalAuthor Commented:
Access is not a good choice for Web database, because there are around 200 Users.
SQL Server would be a good option.
ASP.Net with C# can the offing.


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.