Article ID: 290627 - View products that this article applies to.
This article was previously published under Q290627
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access project (.adp).
For a Microsoft Access 2000 version of this article, see 218812
You cannot install the Microsoft SQL Server 2000 Desktop Engine through the Microsoft Office XP Setup program. There is a separate Setup program that you use to install the SQL Server 2000 Desktop Engine.
NOTE: The previous version of Microsoft SQL Server 2000 Desktop Engine is named Microsoft Data Engine (MSDE).
The Microsoft SQL Server 2000 Desktop Engine is a technology that provides local data storage that is compatible with Microsoft SQL Server 2000. Because the SQL Server 2000 Desktop Engine shares the same data engine as Microsoft SQL Server, most Microsoft Access projects or client/server applications run on either version unchanged.
NOTE: Unlike Microsoft SQL Server 2000, the SQL Server 2000 Desktop Engine has a 2-gigabyte database size limit, does not support Symmetrical Multiprocessing (SMP) on Microsoft Windows 95 or later, and when using Transactional replication, cannot be a replication publisher (although it can act as a replication subscriber).
Installing SQL Server 2000 Desktop EngineIf you have the Microsoft Data Engine (MSDE) installed, it is best to uninstall it before you install SQL Server 2000 Desktop Engine.
The SQL Server 2000 Desktop Engine Setup program installs Microsoft Data Access Components (MDAC) version 2.6 (if MDAC 2.6 or later is not already installed on the computer).
To install SQL Server 2000 Desktop Engine, follow these steps:
Upgrading MSDE to SQL Server 2000 Desktop EngineIf you are going to upgrade MSDE to SQL Server 2000 Desktop Engine, you should do so before installing Office XP Developer. The upgrade described here will delete files from the MSSQL\Bin folder on your computer. Therefore, you will be required to reinstall Office Developer after this upgrade.
To upgrade SQL Server 2000 Desktop Engine, follow these steps:
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.