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

Chapter 2. Access Projects > SQL Server and MSDE

SQL Server and MSDE

Access projects from Access 2002 (part of Microsoft Office XP) work together with SQL Server 2000 and 7, as well as with MSDE 2000 and Microsoft Data Engine 1 (MSDE 1). You need to be aware of inconsistencies between certain releases, because a variety of versions and different releases of servers and Access applications need to talk to each other.

Access 2000 (part of Office 2000) can work with SQL Server 7 and MSDE 1. It also works, to a degree, with Microsoft SQL Server 6.5 (with Service Pack 5 installed), SQL Server 2000, and MSDE 2000. A service pack for Access that eliminates the problems with SQL Server 2000 and MSDE 2000 is available. Microsoft provides the Access 2000 and SQL Server 2000 Readiness Update at http://www.microsoft.com/downloads. You can find it by selecting Access 2000 from the Product Name list on the Microsoft Downloads Center page.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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