 |
|
|
Why Upgrade to Microsoft SQL Server Technologies
SQL Server is a client-server database management system. Unlike file-based databases, clientserver
database engines manage read-write operations to the database. Because of this, clientserver
databases such as SQL Server can handle many more concurrent users and vastly greater
amounts of data. SQL Server is designed to meet the most demanding database application
requirements for the enterprise, including operational and decision support systems
implemented today and in the future.
The disadvantages of using Microsoft Access Databases in an Enterprise Environment are:
-
Has a practical limit of 20 concurrent connections
-
Online backup tools are not available. Microsoft Access uses the file share model; the
entire database is locked at the file level as soon as the first user accesses it. This means
that no reliable mechanisms exist for performing backups of the database file unless all
users are disconnected.
-
Is susceptible to accidental deleting/moving of database file simply through browsing
the network folder
-
Microsoft Access is not a scalable solution.
-
Microsoft Access is not intended as an inherently reliable solution.
-
When Microsoft Access databases encounter an error or connection problem, the
database may become corrupt. A corrupt database generally locks out all users of the
database, and generally results in business disruption and infrequent data loss.
-
Security. Microsoft Access is built on a file-based database engine, which can be
accessed through Windows Explorer. Thus, very easily employees can copy the
database file to a CD or USB stick or even attach it to an email and pass it on to your
competitor.
For more information on this topic please lookup the following document:
http://download.microsoft.com/download/5/d/0/5d026b60-e4be-42fc-a250-2d75c49172bc/when_to_Migrate_from_Access.doc
|
|
|
