• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 8: Appendix > Installing the Microsoft SQL Server Data Engine (MSDE)

Installing the Microsoft SQL Server Data Engine (MSDE)

If you intend to build Microsoft Access projects (.adp files), which link directly to a database defined in Microsoft SQL Server, you should install the Microsoft SQL Server Data Engine (MSDE) on your desktop machine to facilitate building and testing your application. MSDE is a special version of Microsoft SQL Server 2000 configured to run on either operating system supported by Microsoft Office 2003—Windows 2000 SP3 or Windows XP. With MSDE installed, you can use a Microsoft Access project file to create databases and define tables, views, diagrams, and stored procedures that you can later move to SQL Server on a network. You normally install MSDE on your desktop machine. However, you can also install MSDE on a server. If you need to install MSDE on a server, you must install it from that server’s console.

MSDE has its own Setup program—you can’t install MSDE using Office 2003 Setup. To get ready to run MSDE Setup, insert the first of your Office 2003 Setup discs. If Office 2003 Setup starts, click Cancel. Choose Run from your Start menu, enter the following, and click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint