Why is EasyBus converting all software from the Microsoft® Access database platform to Microsoft® SQL Server?
In the late 1990’s EasyBus® software was originally designed around the needs of small to mid-sized school districts, many of whom had simple technology infrastructures. Microsoft® Access allowed us a database that was free to distribute and easy to install and manage. However, Access has many limitations: • It does not scale well; as the size of the database approaches 100MB it slows down, and becomes prone to corruption (which means all data can be lost). • Access is not designed to handle more than 10 simultaneous users, and rarely handles more than a half dozen users well. Some of our competitors are still trying to make Access work on a web server. This is doomed to fail. Consider the following quote directly from the Microsoft website: “Access isn’t designed to create Web sites. The Data Access Pages are of limited use in intranets, but not on the Internet. The underlying Jet engine is also not useful, except when the number of simultaneous users is low. Access is optimized for W
