O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server/MSDE Databases

In Chapter 2, “Access Projects,” we covered the basic differences between Access mdb and SQL Server/MSDE databases. We now more closely examine the SQL Server/MSDE structure and components.

The actual database server runs in the background as a process on the computer where SQL Server or MSDE is installed. Under Microsoft Windows NT or Microsoft Windows 2000, the SQL Server process is a service, and under Microsoft Windows 98 or Microsoft Windows Me it is a regular program that runs in the background.

The database server process manages the databases and answers calls that are sent to it, usually over the network.

Databases

The SQL Server/MSDE database names are used to access the databases. In contrast to Access ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required