MS Access vs SQL

  • Thread starter Thread starter orchid
  • Start date Start date
O

orchid

I'm currently working to create a website access for
countries to update their statistics data.
These data are supposed to be consolidated in one form.

I have been wondering whether I should use MS Access or
SQL for this application. Can anybody please help me to
explain some of the advantages and disadvantages of using
MS Access and SQl?

Thanks a lot for your kind attention.
 
For a web site, I would use stored procedures with sql Server. This is much
more scalable and supports many more concurrent users.
 
Further to the other reply, let's get your terminology right!

MS Access is a front-end development tool. It is not, >itself<, a database
product.

Access is often used in conjunction with the database product, Microsoft
Jet. But MS Access can also be used in conjunction with many other database
products, including (but not limited to) the database product Microsoft SQL
Server.

SQL is a data retrieval language that is used by many database prodcts,
including (but not limited to) MS Jet and MS SQL Servir.

HTH,
TC
 
Back
Top