PivotTables linked to Access Database
 

Hi there

I have a workbook with PivotTables retrieving summary data directly
from Access Databases.

Can anybody tell me:

Firstly -
How do I determine the folder/ location of the .mdb file that the data
is being read from.

Secondly -
How do I change the PivotTable to read the data from a different
folder / location or a different mdb file if the database is renamed.

Any help appreciated.

Thanks

Hilton