Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-10-2020, 07:02 AM
catflap's Avatar
catflap catflap is offline Data connection to Access queries and refreshing Windows 7 64bit Data connection to Access queries and refreshing Office 2013
Advanced Beginner
Data connection to Access queries and refreshing
 
Join Date: Aug 2015
Location: UK
Posts: 72
catflap is on a distinguished road
Default Data connection to Access queries and refreshing

Hi




I've connected my excel sheet to 4 separate queries in the same Access database. I did this one at a time via the 'Get Data from Access' button. The data is just inserted as tables in separate tabs in the excel file. I then have a couple of pivot tables based on 2 of the tables.


When I refresh the data to reflect changes made in Access, I find I can only refresh one table at at time (right click refresh on one of the list items) - if I try to refresh one of the other tables afterwards I can an error:


The query did not run, or the database table could not be opened


If I close and save the file, I can then go in again and refresh a different table and it works, but I can still only do one before I have to close and restart.


Is this an issue with how I've attached the data? - or some sort of security setting?


Thanks for reading!
Reply With Quote
  #2  
Old 06-11-2020, 08:18 AM
catflap's Avatar
catflap catflap is offline Data connection to Access queries and refreshing Windows 7 64bit Data connection to Access queries and refreshing Office 2013
Advanced Beginner
Data connection to Access queries and refreshing
 
Join Date: Aug 2015
Location: UK
Posts: 72
catflap is on a distinguished road
Default

Hi


I just tried setting up an ODBC connection from Excel instead of going down the 'Get Data from Access' route.



This seems to work much better!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Losing data graphics when refreshing external data Tom_Solen Visio 0 02-11-2019 04:47 PM
Macro for automatically refreshing Data connection on Closed excel workbook. ramzan11b Excel 1 11-24-2017 08:55 AM
Merge Object and not displaying Access Queries with VBA jmo Word VBA 11 01-07-2016 04:29 PM
Data connection to Access queries and refreshing Mailmerge with Access queries optiontips.in Mail Merge 2 11-21-2011 03:12 AM
Data connection to Access queries and refreshing Refreshing Data in Excel jamal420 Office 3 06-13-2005 03:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft