Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

ACC2000: Microsoft Data Engine (MSDE) Is Not Installed by Office 2000 Setup


View products that this article applies to.

This article was previously published under Q218812
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

For a Microsoft Access 2002 version of this article, see 290627 (http://support.microsoft.com/kb/290627/EN-US/ ) .

↑ Back to the top


Summary

You cannot install the Microsoft Data Engine (MSDE) through the Office 2000 Setup program. There is a separate Setup program that you use to install the MSDE.

↑ Back to the top


More information

To install the MSDE, follow these steps.

NOTE: You can install the MSDE only from versions of Office 2000 that contain Microsoft Access.
  1. Insert the Office 2000 CD number 1 into the CD-ROM or DVD-ROM drive.
  2. In Windows Explorer, locate the following folder:
    \SQL\x86\Setup
  3. In the Setup folder, double-click the Setupsql.exe file.
The Microsoft Data Engine (MSDE) is a new technology that provides local data storage that is compatible with Microsoft SQL Server 7.0. Because the MSDE shares the same data engine as SQL Server, most Microsoft Access projects or client/server applications run on either version unchanged.

NOTE: Unlike SQL Server 7.0, the MSDE has a 2-gigabyte database size limit, doesn't support Symmetrical Multiprocessing (SMP) on Windows 95 or later, and when using Transactional replication, can't be a replication publisher (although it can act as a replication subscriber).

↑ Back to the top


References

For more information about the Microsoft Data Engine, click Microsoft Access Help on the Help menu, type work with a Microsoft Access project in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top


Keywords: KB218812, kbfaq, kbclientserver, kbinfo

↑ Back to the top

Article Info
Article ID : 218812
Revision : 2
Created on : 6/24/2004
Published on : 6/24/2004
Exists online : False
Views : 340