An Introduction to the SQL Server 2000 Desktop Engine
Microsoft Access (Jet) is a powerful relational database, and, as such, it provides a useful tool for those needing a desktop database. Many need more. Microsoft markets SQL Server Desktop Engine as an alternative to Jet for those instances when you need a database server that can be easily distributed and installed, and you don’t want to spend a lot of money. The SQL Desktop engine (known as MSDE 1.0 in Office 2000) is a data engine that’s based on core SQL Server technology Basically, you’re getting the full-blown SQL Server engine with some limitations (which we’ll discuss later). In this chapter, we’ll view just what SQL Desktop is and who it services. Along the way, we’ll compare Access, SQL Desktop, and SQL Server features and requirements.
KeywordsEnterprise Manager Access User Main Menu Database File Installation Process
Unable to display preview. Download preview PDF.