Dynamism for linked tables.

[amey.gupte]

I have certain data that is dynamic and I have stored it in an excel
file that I have linked to a table in access. This works fine for me.
However the only glitch is that when I have to transfer my application
from one PC to another or one location to another I need to refresh the
location of the linked tables manually. Is there a way to automate this
or make it dynamic?

-Amey

 

[John Nurick]

Hi Amey,

A web search for something like
access relink tables
should find plenty of approaches. In particular, there are a couple of
good articles at http://www.mvps.org/access/

 

[Douglas J Steele]

http://www.mvps.org/access/tables/tbl0009.htm and
http://www.mvps.org/access/tables/tbl0010.htm