The purpose of this article is to explain the differences between Microsoft Access and SQL Server. We also explain why DotActiv no longer uses Microsoft Access.
Key Differences
Microsoft Access and Microsoft SQL Server are both database applications.
The major difference between the two is in how the software is used.
Microsoft Access is used in small business applications. Microsoft Access is also unable to handle large quantities of database queries.
On the other hand, Microsoft SQL Server is used for medium to large businesses that need a solution for optimised data processing.
Interface
The Access interface is mainly for end users unfamiliar with more complex database interaction. Access allows users to create tables and queries by manipulating icons and using wizards.
SQL Server is more for the expert and only gives the user a command-line interface, so it is less intuitive and takes a longer time to learn.
Tables
Microsoft Access and SQL Server both support relational tables.
Relational table design allows users to link data from one table to another.
SQL Server has one added ability in that it supports temporary tables. Temporary tables are structures made on-the-fly and deleted when the user is done with the query.
Recovery
An Access file can only be recovered from corruption or data failure if the database was backed up to another drive.
SQL Server supports automated backup procedures to a network drive or media disk. SQL Server also allows programmers to rollback procedures using transaction logs.
Why DoActiv No Longer Uses Microsoft Access
Microsoft Access has been phased out of the DotActiv software we have optimised our software to support a more advanced database interface.