Microsoft SQL Server 2000 Desktop Engine is not installed by Office XP Setup

Article translations Article translations
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.
Expand all | Collapse all

Summary

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).

More information

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 Engine

If 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:
  1. Insert the Microsoft Office XP CD 1 into the CD-ROM or DVD-ROM drive.
  2. In Windows Explorer, locate the following folder:
    \MSDE2000
  3. In the MSDE2000 folder, double-click the Setup.exe file.

Upgrading MSDE to SQL Server 2000 Desktop Engine

If 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:
  1. Insert the Microsoft Office XP CD 1 into the CD-ROM or DVD-ROM drive.
  2. In Windows Explorer, locate the following folder and then copy the MSDE2000 folder to a folder on the local computer (C:\MyFolder). :
    \MSDE2000
  3. For Microsoft Windows 98 or Microsoft Windows Me, edit the [Options] section of the Setup.ini file as follows:
       [Options]
       UPGRADE=1
       UPGRADEUSER=sa
    						
    For Microsoft Windows NT 4.0 or Microsoft Windows 2000, edit the [Options] section of the Setup.ini file as follows:
       [Options]
       UPGRADE=1
    					
  4. Use the following switches to run Setup from the command line:

    NOTE: In the following statement, an underscore (_) at the end of a line is used as a line-continuation character. Remove the underscore from the end of the line when you type this statement.
    C:\MyFolder\setup.exe /i Setup\SqlRun01.msi /settings setup.ini _
    /l*v c:\msde_install.txt
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 290627 - Last Review: October 24, 2013 - Revision: 2.0
Applies to
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbnosurvey kbarchive kbclientserver kbhowto KB290627

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com