Creating Queries for the Web

When you’re designing a web database that will be published to a Microsoft SharePoint server running Access Services, you must create all queries that you want to run on the server from scratch. Access 2010 is the first version of Access to include the new features of web support with Access Services running on top of SharePoint server, which means web queries are a completely new object type in Access databases. You cannot convert client queries used in existing databases into web queries and make them run on the server. You can, however, still run your saved client queries in a published application from Access client.

Throughout this chapter and the previous chapter, you’ve been learning how to create simple queries ...

Get Microsoft® Access® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.