Linked Table Manager

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Access 2003 and I am having trouble with the Linked Table Manager. I
have a linked table that I want to change the location of the link, however
when I go to the Linked Table Manager the field is blank and there is no
Table to be linked. I verfied that the table is indeed currently linked
correctly and I am able to open the table. Is this a "bug" with Access 2003
or is this some sort of Security lock down setting??
 
ethan0818 said:
I have Access 2003 and I am having trouble with the Linked Table
Manager. I have a linked table that I want to change the location of
the link, however when I go to the Linked Table Manager the field is
blank and there is no Table to be linked. I verfied that the table
is indeed currently linked correctly and I am able to open the table.
Is this a "bug" with Access 2003 or is this some sort of Security
lock down setting??
Click to expand...

From the help file:

Open the database that contains links to tables.

On the Tools menu, point to Database Utilities, and then click Linked Table
Manager.

Select the Always prompt for new location check box. <- Is this what you
were missing?

Select the check box for the tables whose links you want to change, and then
click OK.
In the Select New Location of <table name> dialog box, specify the new
location, click Open, and then click OK.


Notes
The Linked Table Manager doesn't move database or table files. For
information about moving database or table files to a new location, search
Microsoft Windows Help. Once you have moved a database or table, you can use
the Linked Table Manager to refresh links.

The Linked Table Manager can't refresh links to Microsoft Access tables
whose names were changed after they were linked. You must delete the current
link, and then link such tables again.

Hope that helps.
 
Joseph - Thanks for the reply. Actually, when I open the Linked Table
Manager, I literally cannot see my linked tables and cannot choose which
tables I want to refresh the links. My temporary fix is to delete the linked
table and then re-link it. But it is more of an annoyance that the Table
manager is not funstioning properly. I do see the Always prompt for a new
location check box, but I don't think that is my issue. So I 'm not sure if
there's a glitch in the Access 2003 or if this is specifically related to our
company's rollout of Office 2003. Have you heard of this happening?
 
Back
Top