Access Reference

[Guest]

I have a workbook that in my testing is pulling data from and writing data to
an access .mdb file that is on a path, say, h:\mypath. But when this goes
into production, I will be moving that .mdb file to somewhere else on the
network. My question, is there a way to change the references to the
external data that is displayed in various parts of this workbook, or am I
better off deleteing (not sure how to do this either) all the references and
reestablishing them to the relocation .mdb location?

 

[Guest]

Hi Mike,

See if you can find the path by doing this:

Click on a cell within the data range that is linked to the mdb file.

Data menu>>Import External Data>>Edit Query

In the Connection box (if the data is linked this way) you should see the
path to the file.

Hope this helps,

Sean.