Linking to Access Queries

[cwchurch]

I have successfully been using Powerpivot to display Pivot Tables and Charts for reporting based on linked Access queries for the last six months. I change the ODBC links in my Access project to point to a different SQL database, and then simply refresh the linked queries and the reports successfully rebuild with the new data. However, for some unknown reason, those queries will no longer refresh and are even not displayed in the list of tables and queries to link to (from the wizard). It does display the tables and most of the queries, just not the ones I had linked to previously. I have not made any changes to the queries or databases. In Access, the queries do run and return results . Help!

 

[RonB1111]

Perhaps when you changed the ODBC links in Access to the different SQL database, you didn't actually "link" the tables but rather just did an "import" of the table. This would bring the data in the table over 1 time with no refresh capability.