Access V SQL

Results 1 to 2 of 2

Thread: Access V SQL

  1. #1
    Join Date
    Dec 1969

    Default Access V SQL

    Could someone briefly outline the advantages of SQL vs Access ? <BR><BR>I&#039;d just like to know ideally how many hits/users Access would have a problem with and how much slower/inefficient it is versus SQL server.<BR><BR><BR>Thanks for any info.<BR><BR>-M

  2. #2
    Join Date
    Dec 1969

    Default RE: Access V SQL

    More than a dozen concurrent users can kill access. SQL server can handle thousands of concurrent users. Also, SQL Server allows you to use stored procedures, which are compiled queries that run much faster than standard queries. <BR>Basically, Access is a decent development tool (toy), SQL Server is an enterprise level database solution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts