Share this Page URL

Chapter 14. Understanding Access Project... > Setting Up the SQL Server Database E... - Pg. 500

Understanding Access Projects 500 Setting Up the SQL Server Database Engine Microsoft SQL Server is one of the database programs used widely by organizations and busi- nesses. Learning how to set up an Access project so that you can make use of data stored in SQL Server databases greatly expands the amount of data a user of an Access database application can retrieve and analyze. SQL Server 2000, the version of the product current when this book went to press, comes in different editions--SQL Server 2000 Enterprise Edition, SQL Server 2000 Standard Edition, SQL Server 2000 Personal Edition, and others. These editions are stand-alone products that are typically in- stalled on network servers. (SQL Server 2000 Personal Edition is usually installed on client com- puters for users who require local SQL Server data storage.) SQL Server 2000 Desktop Engine (formerly known as the Microsoft Data Engine, or MSDE) is an edition of SQL Server that can be distributed by software developers with applications they build that require SQL Server. The Desktop Engine also comes with Microsoft Office 2003, so we'll use the SQL Server Desktop Engine for the examples we present in this chapter. (Describing how to install and configure a stand-alone SQL Server database is beyond the scope of this book. For information about working with a full edition of SQL Server, you should refer to the sources cited at the end of this chapter or review the information provided on Microsoft's Web site, at http://www.mi- SQL Server 2000 Desktop Engine can be installed on computers that run Microsoft Windows 2000 or later. The SQL Server Desktop Engine is intended for smaller computer systems, including a server used by a small workgroup or a computer that a single user works on. You should consider using an Access project that's connected to a database on SQL Server 2000 Desktop Engine if you expect that the number of people who will use your database or the scope of the tasks and the amount of data your database manages will increase over time. Using an Access project points you