0
SQL Server (T-SQL) can scale up to much larger tasks than the Access (JET SQL).
In terms of flavors, think of Access as limited to tablespoons while SQL Server (and other databases), can accept ladles, pots, vats, or barrels of data. (To extend the analogy, Big Data in the tera- and petabytes get...