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

Chapter 32. Upgrading Access 97 and 2000... > Moving from MSDE 1.0 to the SQL Serv...

Moving from MSDE 1.0 to the SQL Server 2000 Desktop Engine

When you upgrade from Office 2000 to 2003, your existing MSDE 1.0 installation remains intact, and your existing ADP, DAP, and linked Jet databases continue to connect to the local instance of MSDE 1.0 installed by Office 2000 or the remote server specified by the front-end application’s ODBC or OLE DB/ADO connection string. When you open the Access 2003 version of NorthwindCS.adp, however, you receive the message shown in Figure 32.8. The Access 2000 version of the NorthwindCS database’s Employees table stores bitmaps in the Photo field; the Access 2003 version has links to nine EmpIDx.bmp files in the ...\Office11\Samples folder.

Figure 32.8. This message appears when you open Access 2003’s NorthwindCS.adp sample application connected to the MSDE 1.0 version of the NorthwindCS sample database.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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