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

OK, I'll demonstrate my stupidity, but what's the main differences between MS Access and MS Sequel Server?

OK, I'll demonstrate my stupidity, but what's the main differences between MS Access and MS Sequel Server?
0
wellspringfv
Asked:
wellspringfv
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
ms sql server is "mainly" a large-scale server database product.

ms access is mainly a "quick and dirty" small-scale desktop database product, with vba+forms development integrated.

0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

Access is a complete development environment where SQL Server is simply a database engine.

Access includes the ability to create forms and reports and tie that all together with marcos or code. It also comes with a default database engine, which is JET. JET however is a fairly simple database engine lacking many features that are found in other db engines such as SQL server. JET was designed and is intended for small workgoup/department level projects.

Access can use db engines other then JET. In fact SQL server is one of them. It even has a native interface to SQL Server (called ADP's), but that is being phased out in the next release. Stepped on too many toes I guess<g>.

HTH,
JimD.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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