ChangeLink

[PC User]

I have A2K and I was wondering if I can programmically activate the
Link Manager to change the source of my backend data? I'm looking for
the ability to change directories of my links? I have a backend for
testing and a realtime backend. I test my programming with data that
won't accidently corrupt my realtime data. That's two different
backends which I switch between when I have the need.


Thanks,

PC

 

[Douglas J. Steele]

Take a look at what at's in http://www.mvps.org/access/tables/tbl0009.htm at
"The Access Web" for how to do this using VBA

 

[George Nicholson]

take a look at
http://www.mvps.org/access/tables/tbl0009.htm
see if it gives you any ideas.

 

[Bill Smith]

take a look at
http://www.mvps.org/access/tables/tbl0009.htm
see if it gives you any ideas.

Tables: Relink Access tables from code
Do I call this function in the On Open event of the startup form?

PC

 

[George Nicholson]

Do I call this function in the On Open event of the startup form?

I think you want to call a variation of that function on demand...

Table links are stored with the FE db, so the only time anyone "needs" to
relink is if the pointers to the BE become invalid. That is what the Access
Web code was designed to do: determine that existing links are broken,
prompt the user for a new BE location and relink all linked FE tables to the
new BE location. This is best done when the db opens.

I believe you were asking about something closer to a "re-link on demand"
functionality. This is not quite the same thing and will require a
variation of that code (i.e., start with "prompt for new location" & relink
tables, ignoring whether links are broken or not).