benefits of sequel server vs. access database?

thinking of switching from Access unto Sequel. need some input thanks

4 Answers

Relevance
  • 1 decade ago
    Best Answer

    Access databases are relatively inexpensive. In fact, you can open an Access database, modify the database structure using SQL, fetch records, modify and update data, and delete records using a Visual Studio application without buying the Access product itself.

    Access databases have their disadvantages, however. They have some size restrictions (at most around 2GB per database), provide little in the way of user access control (only database-level passwords), and have little support for multiple concurrent users.

    SQL Server (usually pronounced "sequel server"), on the other hand, provides support for huge databases (up to 1TB = 1,024GB per database), multiple simultaneous users, and very detailed user access controls. SQL Server's big drawback is its price. Depending on your installation, SQL Server licenses can cost thousands of dollars.

  • Anonymous
    1 decade ago

    The big difference is that SQL server does not provide anything for creating an application to use the database.

    SQL Server supports much larger databases, has far better multi user support, is faster and allows much more control over your databases.

  • adamek
    Lv 4
    3 years ago

    the two had user-friendly messages of discarding the complicated dogmas of their make sure's faith and specializing in fairly being a extra robust individual. the two had human beings coming after them that re-complexified what they stated. regrettably, their similarities are misplaced on maximum up-to-date-day Christians who view their own dogma as some thing which could get carry of their timeless loyalty, as destructive to a reasoned set of policies which could make experience (and that i basically factor to Christians simply by fact Buddhists do no longer tend to declare issues like "there is not any similarity").

  • 1 decade ago

    First of all Access is limited to 10,000 records. SQL is unlimited.

Still have questions? Get your answers by asking now.