I've been put on a team with another individual to develop a SharePoint list management program. Due to the size of the list (something like 300 daily users and lists that can exceed 20K lines) We decided to use a normalized Access database. I had intended on building queries and resultsets to interface with SharePoint.
I see Access TABLES and SharePoint lists can be joined, but is it possible to associate a SharePoint list with an sccess Query Resultset?
Or will I need SharePoint to feed me the parameters I can use in a make table query and dynamically link that table back to SharePoint?