SQL Server database

The simplest possible SQL Server arrangement is an extension of the one shown for an Microsoft Access database. There is still a security file, but there is now a connection file in place of the database file, and there is a server to hold the SQL Server database.

From the user’s point of view nothing has changed, because they see a connection file that appears to be a database. The points to remember are still:

Users gain access to databases through the security file.
A security file can control access to several databases.
Each database has just one security file associated with it.
Additionally, users can make use of functionality specific to SQL Server databases.

For an administrator, there are differences:

There is a server running SQL Server, with consequent changes in performance and administration.
There is an opportunity to centralize the operation and administration of multiple databases, and automate more of the routine administration.
There is an opportunity to operate another level of security between the user and the data.

This configuration is more secure than Microsoft Access.