• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

SQL vs Access in ASP.net

Hi

I have an ASP.net web application and have been trying to set up a SQL backend but am getting
a network error and am fed up with the utter stupidity of the Microsoft team in this regard, because the same error is all over the net with no intuitive answer
I am an Access developer and want to use an access backend. Users of my site will presss a button that returns a simple select query. Can up to 50 people doi this at once? Can Access handle that.
0
Murray Brown
Asked:
Murray Brown
1 Solution
 
Alpesh PatelAssistant ConsultantCommented:
SQL Server can handle better concurrent transactions.
0
 
soujanya_gCommented:

Hi

The basic difference between these are, If you have large volume of the data the people would go for SQL Server
www.databasedev.co.uk/ms-access-vs-sql-server.html


0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
That is the answer that I am looking for. Nice one ;)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now