Pivot tables lock Access database in 'ReadOnly' mode - Microsoft Community

For years we have used processes that have Access queries extract data from SQL tables and populate data in Access tables. We then have pivot tables that pull information from ...

answers.microsoft.com