Hi I hope you can help. i have an access db linked to sharepoint - everything is working as expected apart from my queries. I have a really simple query setup in access to select data from 2 tables (access related tables_ and do a count on the number of users, this runs in access without error. i then exported the query to an access table, then linked to a sharepoint list so i can display the results of the query in a list on sharepoint, this again works well. The trouble is if data in the 2 tables that have been queried is updated - my query does not automatically update in sharepoint - can any one help please!

Which version of Access ? Which version of SharePoint ? ModeratorSP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx Both also have links to extensive book lists and to (free) on-line chapters