Catálogo de publicaciones - libros

Microsoft Access 2007 is missing support for two technologies used by developers who want to get data onto the Internet: Active Server Pages (ASP) and Data Access Pages (DAPs). Never being a great fan of DAPs, I will not miss them. When I first started out with Access and the Web, I made great use of the Save As ASP feature in Access to make simple datasets available. In this chapter, we will be looking specifically at what more you can do once you have your Access application on Windows SharePoint Services (WSS) and how you can use the replacement to FrontPage 2003, SharePoint Designer (SPD), to make your data available via the Internet. SPD is designed to work directly with SharePoint and can be used as a design and development tool when communicating with WSS sites. However, you can also use SPD to create standard web pages displaying data from Access 2007. In this chapter, you will learn about both options.

Many Access developers and power users occasionally need to use Microsoft Access data without actually using Access as the front end. For example, you may have a requirement to make data available on the Internet or for a web-based data collection form. Often, the time you have to complete such small-scale applications is usually short, while the learning curve required to develop them could be long, given the languages and development environments involved.

In this chapter, thanks to many of the members of AccessD who gave permission, I will be providing several examples of Access VBA using DAO, ADO, and some Windows API calls. The code comes from working Access developers and is free for you to use in any application. Where copyright is included in the code headers, I request that you retain it. The code is not categorized into specific functional areas. Where appropriate, I have also added the question that resulted in the code example in an attempt to place it into some context. However, feel free to sign up to AccessD (http://databaseadvisors.com/mailman/listinfo/accessd) and ask questions about specific code yourself! The code examples are available for download with the book’s demonstration databases and within the archives of AccessD.