Summary


This chapter provides a succinct introduction to Web techniques based on data access pages, Office Web Components, and FrontPage. These three technologies are a natural extension of your Access development capabilities and enable you to easily create powerful Web solutions. Much as an Access database file (.mdb file) or Access project (.adp file) acts as a repository for different kinds of objects in a single project, a Web site managed by FrontPage can play a similar role for the files in a Web application. In addition, FrontPage offers powerful development and formatting capabilities of its own. This chapter examines the use of FrontPage with data access pages and Office Web Components .

Data access pages are an important technology because they enable you to create forms and reports on the Web for your Access and SQL Server databases. Furthermore, data access pages have a look and feel that is similar to Access forms and reports . This will make your clients feel right at home when they use your solutions on the Web. In some cases, you can actually copy existing Access forms and reports to data access pages with little or no editing. Because of security and client browser requirements, data access pages might be best suited to intranet solutions or Internet solutions that run on a virtual private network.

Office Web Components offer spreadsheet, chart, and pivot table controls that can exist on data access pages or on standalone Web pages. While data access pages must be developed from Access, you can create solutions with the spreadsheet, chart, and pivot table components from Access or FrontPage. The same IDE that you use to code event procedures for data access pages also works for standalone Web pages with Office Web Components. While the Office Web Components offer a convenient graphical user interface, you may occasionally find that you obtain more flexibility and less exposure to security faults that block page display by using code behind a page instead of manual development techniques.




Programming Microsoft Office Access 2003
Programming MicrosoftВ® Office Access 2003 (Core Reference) (Pro-Developer)
ISBN: 0735619425
EAN: 2147483647
Year: 2006
Pages: 144
Authors: Rick Dobson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net