Moving the link to Acess to another location

A

Adam

Dear All

Office 9

I have a spreadsheet which is linking to an Access database in My Documents. I want to put this spreadsheet on the network drive and also move the access database there

But how do I edit my links/get data query in excel to choose the access database on the network drive and not from my documents???
 
C

Charlie

Have a look at "Update references to a workbook that has
been renamed or moved" in the excel help file.

Charlie O'Neill
-----Original Message-----
Dear All,

Office 97

I have a spreadsheet which is linking to an Access
Click to expand...
database in My Documents. I want to put this spreadsheet
on the network drive and also move the access database
there.
But how do I edit my links/get data query in excel to
Click to expand...
choose the access database on the network drive and not
from my documents???
 
Top