Easy way to relink to BE when it moves?

  • Thread starter Thread starter David Portwood
  • Start date Start date
D

David Portwood

If the BE of my split app moves (for whatever reason), is there an easy way
to relink the FE/BE? What I had to do today was delete each link in the FE
one by one, then re-import/relink to the BE. Took quite some time, and I may
have to do it again soon. I tried, but apparently you can't use shift select
to select multiple links and delete them all at once.

If you know of an easier way than deleting links one by one etc., please
respond.
 
On Wed, 9 Jan 2008 18:18:23 -0800, "David Portwood"

How about using the Linked Table Manager?
-Tom.
 
If the BE of my split app moves (for whatever reason), is there an easy way
to relink the FE/BE? What I had to do today was delete each link in the FE
one by one, then re-import/relink to the BE. Took quite some time, and I may
have to do it again soon. I tried, but apparently you can't use shift select
to select multiple links and delete them all at once.

If you know of an easier way than deleting links one by one etc., please
respond.
Click to expand...

I recently tackled a very similar problem.

I created a table in the FE that enumerates all the table names
subject to (re)linking. Using this as a record source, I wrote a VBA
procedure that loops though the table names, drops the current table
objects (i.e., the ones with outdated/broken links), and creates a new
linked tables using the new BE path.

This works splendidly for me since I have only one FE to update and
maintain and the FE already knows where to expect the BE. As such I'm
not sure if this will work for you, but hope it gives you some ideas...
 
In A2000 the link table manager doesn't allow me to browse for a new target
for linking. I can refresh existing links, but can't modify a link path. At
least, I couldn't see any way to do that. Maybe you are using a later
version of Access that has that capability.
 
Sounds like your knowledge of VBA is considerably greater than mine.

I will look into my Access text and see if I can find anything that might
pertain, but smart money would probably bet that next time I'll still be
deleting the table links manually, one by one, just like before...
 
In A2000 the link table manager doesn't allow me to browse for a new
target for linking.
Click to expand...

There isn't a "Always prompt for new location" checkbox on A2000's linked
table manager?

If there is, check it. That should allow you to browse to a
new/moved/renamed backend and change all specified links to that location.
 
Hi

As was adviced by George, activate Tools>Database Utilities>Linked Table
Manager and check "Always prompt for new location" there;
Select all tables/tables you want to relink. OK;
In Select New Location window, point to BE in it's new location. OK.

PS. This works with Acess2000 for sure - I myself use Acess2000 too.
 
Yes, there is. That dialogue box has remained pretty much the same
through several versions.

HTH
 
David said:
If the BE of my split app moves (for whatever reason), is there an easy way
to relink the FE/BE? What I had to do today was delete each link in the FE
one by one, then re-import/relink to the BE. Took quite some time, and I may
have to do it again soon. I tried, but apparently you can't use shift select
to select multiple links and delete them all at once.

If you know of an easier way than deleting links one by one etc., please
respond.
Click to expand...

I store the location of the back-end in UNC format in an .ini file in
the same directory as the front-end app. The .ini file points to the
server, share, path and file name of the BE.

Lots of advantages here; if I copy in a new FE my startup code reads the
..ini file to determine what BE file to link to. Users never have to see
the linked table manager.

The .ini file survives installs of new versions; doesn't involve
registry use and can easily be modified by manual edit or script if
necessary.

Code that executes on startup (AutoExec macro and function) checks
validity of current linked tables and re-links if necessary.

Just another possible way of handling this...

--
'--------------------------
' John Mishefske
' UtterAccess Editor
' Microsoft MVP 2007, 2008
'--------------------------
 
Back
Top