Client inherited some files with pivot tables that are pulling data from an
Access database. The access database was moved to a different drive so when
she tries to refresh the database, she gets an error that the file can not be
found. We have tried to redirect it to the correct location by browsing and
selecting the file but we then get a dialog box asking for the administrator
password. If we leave the pasword field blank, we then get a message that
query can not be edited with MS Query. She is able to open the database and
is not prompted for any passwords. How can we redirect the pivot table to the
new location of the database?
--
maryj