Changing Links to access databases

R

RozBentley

I have an access database (2007) containing data which I have summarised via
Pivot Tables in an Excel spreadsheet (2007) using Microsoft query (and pivot
the data in excel). The access database contains realtime information, and
hence the pivot tables are refreshed daily to review performance.

I need to move the file location of the database, but when I do this, the
pivot tables are no longer valid, and I can't update them.

I would like to know if there is a way you can move the database and then
update all links in the excel workbook without having to re-build all the
queries individually and link them to the new location of the moved access
database.

Is there a way to update links, similar to how you would in Excel (Data>Edit
Links)

Any advice would be very much appreciated
 
D

Douglas J. Steele

Realistically, I think you'd be better off asking in an Excel newsgroup than
an Access one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Database links? 3
Converting URLs in comments to Markdown-formatted links 2
Dates In Excel 5
Add additional information to excel form after original data entry 0
Help creating a search form in Access XP 0
Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Adding data to MS Access from csv file 0

Top