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

Chapter 25. Designing and Deploying Data... > Moving from Jet to SQL Server Page D...

Moving from Jet to SQL Server Page Data Sources

Creating a DAP with SQL Server 2000 as the data source follows the same process as DAP that connect to Jet 4.0 databases. The only difference is that you create the page in an .adp file instead of an .mdb file, and you use views, functions, or stored procedures in place of Jet queries.

The NorthwindCS.adp project doesn't include sample DAP, but you can convert existing pages to work with SQL Server 2000 databases that contain the tables and queries on which your pages depend. The most common approach is to import the .htm files into an Access project, but you also can change the data source for pages linked in an .mdb file.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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