Moving the link to Acess to another location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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???
 
You must log in or register to reply here.

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
Hypeerlinks in worksheet changed locations from server to workstat 1
Excel Spreadsheets keep moving 0
Linking Acess with Excel 1
linking excel spreadsheet from network 3
excel spreadsheet 2003 wont show content when moved to another par 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Microsoft Query in Excel 4

Back
Top