Ian Morrish just posted a brief Blogcast on using Access to display, query Windows SharePoint Service data. This is an excellent demonstration and has provided me fodder to share with some of the Access junkies that have been "afraid" of SharePoint technologies. In addition, I can demonstrate more of the business power behind WSS/SPS and protect the SQL Server backend (I have been burnt before by Access in a production environment).
Thank you Ian!
http://www.blogcastrepository.com/Office/Contrib/Imorrish/AccessIM.htm
Using Access to report on users who have not completed a SharePoint survey * Get Windows Media Player 9 or above to view this page.by Ian Morrish - 3/15/2005 - Elapsed Time: 2:18 Audio= YesI recently had a customer ask how they could send follow up emails to people who had not completed a server that they were invited to through the WSS add user wizard. Although this is not an out-of-the box solution in WSS it is a solution made possible by the Office 2003 System. By Using Access 2003s ability to link to SharePoint lists via XML Web Services, you can run a query to find unmatched records between the site members and people who have responded to the survey. This would work for any list where you expect users to create a list item. E.g. asset register, annual leave calendar etc.
