Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 22nd, 2006, 01:43 PM
Authorized User
Join Date: Mar 2004
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linked tables problem

Hi all

Appreciate it if anyone can help with this one.

I'm trying to assist a friend of mine who has an Access97 database, to cut a long story short the server the MDB was on finally gave up the will to live this week so I've slaved the harddrive into another machine and copied the fl.mdb and flcore.mdb files onto another drive.

When I open the mdb in A2000 it complains about the linked tables in fl.mdb saying that the path \\server1\data is not valid.

Is there an easy way to tell all the linked tables to use f:\data (my USB drive) without deleting the links and rebuilding them (I didn't write the database so don't really want to cause more of a problem for him)

Best wishes

Old August 23rd, 2006, 10:39 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

The easiest thing to do is to link all of the tables in their current location (use Select All) and they will come over with the same names, but with a "1" added to the end of the table names.

Check to make sure you have all the tables by comparing the old ones with the new ones by name.

Then delete all the old links.

Then rename all the new links to remove the "1"

Doing it in these steps will allow you to visually check every step of the process to make sure you are getting everything relinked.

Total time, about 2 minutes if you work slowly.

Everytime you move the back end, you will need to redo this with the front end.

Does this help?

Old August 24th, 2006, 08:43 AM
Authorized User
Join Date: Oct 2005
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Figgis

If your using AC97 then providing you have it there is an add in for managing linked tables. I think on later versions it is an actual menu item within the tools menu. When you open it you are presented with a list of linked tables. If you click on the select all button and then place a check in the "always prompt for new locations" then click ok it will go through each linked table and prompt you for a new location for the database you are linking to. I use this method myself quite a bit as I have a system with many front ends accessing a group of 3 databases. The method mmcdonal suggested also works. Mine is just an alternative.

Old August 24th, 2006, 01:15 PM
pjm pjm is offline
Authorized User
Join Date: Jul 2006
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts

For 2000 & later the menu for managing your linked tables is:

     Tools/Database Utilities/Linked Table Manager


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked Tables edojan Access 1 July 20th, 2006 10:49 AM
Finding linked tables elansolutionsltd Access VBA 4 January 16th, 2006 11:00 PM
Linked Tables ru1 Access 1 September 21st, 2005 07:24 AM
help with two linked tables query footohi Access 2 August 25th, 2005 10:25 AM
Linked Tables ricmar Access VBA 6 July 28th, 2004 05:08 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.