First Encounter with Dynamic Data Websites

I was just about to follow Scott’s article on Dynamic Data Websites. It appears that drag and drop does not work with a Microsoft Access data source. The user is presented with a magical unsupported data provider message. This is even the case for ODBC, as mentioned in this article.

All the URLs in your Sitemap have the same priority

"All the URLs in your Sitemap are set to the same priority (not the default priority). Priority indicates the importance of a particular URL relative to other URLs on your site, and doesn't impact your site's performance in search results. If all URLs have the same priority, Google can't tell which are more important" - The secret seems to be that if you have thousands of pages then ignore the message and simply change nothing.