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.