This is (I think) a simple question. I have extracted a bunch of data from an Access database using the "Get External Data" function.
If I want to refresh the data, the query that has been created (through MS Query) to extract the data is run when I click on "Refresh Data".
I have just tried updating the data, but it comes up with a "broken link" error, stating that the database my query references is unavailable.
Nothing has changed. The source data is the same as is the query. The query seems to be broken for just this particular extraction. Other data extractions on the same worksheet work fine.
Any thoughts??
If I want to refresh the data, the query that has been created (through MS Query) to extract the data is run when I click on "Refresh Data".
I have just tried updating the data, but it comes up with a "broken link" error, stating that the database my query references is unavailable.
Nothing has changed. The source data is the same as is the query. The query seems to be broken for just this particular extraction. Other data extractions on the same worksheet work fine.
Any thoughts??