SQL Server or Access?

Results 1 to 2 of 2

Thread: SQL Server or Access?

  1. #1
    Ben Edwards Guest

    Default SQL Server or Access?

    Hello,<BR> I was wondering what the the pluses and minuses were for SQL Server and Access. I know that SQL Server is supposed to be a lot more scalable. At which point would it not make sense to use Access anymore? What are the limitations of Access compared to SQL Server? Does anyone know of a good website where I could look at the differences? I will only be accessing these through asp web pages.<BR><BR>Thanks,<BR>Ben Edwards

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Server or Access?

    In my opinion it would never make sense to use Access for web application exept for learning purpose. Simply because Access can&#039;t support more than 8 concurrent users. On the other hand SQL server can support thousands of users. Also with SQL server you can use T-SQL which provides far more superior options and capabilities to Ansi-SQL used in Access.

Posting Permissions

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