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

Chapter 14. SQL Server Integration

In the last chapter, you learned about integrating Access with the World Wide Web. This chapter focuses on integration with SQL Server 2000 using the desktop engine that ships with Access 2002. Now you have an alternative to Microsoft Jet. In particular, you explore the following:

  • the history of the Microsoft Data Engine

  • how MSDE 2000 compares to SQL Server 2000

  • how MSDE 2000 compares to Jet

  • how to install MSDE 2000

  • how to install a sample Northwind application

  • how an Access project compares to an Access database

  • how to create stored procedures and triggers


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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