Linked Table Manager behavior

[CEH]

Having an odd problem..... Maybe I haven't worked with any of my DB's for a few months and just having a brain freeze ....but....... Have a split DB...works fine, no problems... When I open the front end and click on "Tools" "linked table Manager" there is nothing there......... The tables are connected and all works fine..... But why are they not showing? Am I forgetting something from Access 101???????

 

[boblarson]

Do you have your tables set to be hidden? If so, they won't show up there unless you check the appropriate checkbox under the database options General tab if in 2003 or earlier and in the Current Database under the Access options in 2007 and 2010.

 

[CEH]

Well, Bob, I didn't even know you COULD set the tables to be hidden...... But, its in 2003...looked under the general tab in options on the BE..... No box to be checked or unchecked................


I've narrowed it down a bit...... had to reload XP on my machine last week...then Access.... went on remote to the server.... opened a copy of the same front end there..and can see the linked tables... so it is just on my machine... Am I missing an Access update?

 

[boblarson]

Well, Bob, I didn't even know you COULD set the tables to be hidden...... But, its in 2003...looked under the general tab in options on the BE..... No box to be checked or unchecked................

You wouldn't look in the backend, you would look in the FRONTEND. The option to display hidden or system objects is here (in 2003 - I made an error too, it is on the VIEW tab not the General tab):

 

[CEH]

Checked on unchecked on both of those makes no difference............

 

[boblarson]

Checked on unchecked on both of those makes no difference............

So, are you sure you did the linked table manager from the frontend and not the backend?

Can you post a screenshot of your tables in the database window?

 

[CEH]

I thought I had found it....but..........

 

[boblarson]

Hmm, everything looks okay (although the SwitchboardItems table should not be a linked table but should be in the frontend).

So, when you open the linked table manager it shows nothing, huh? No table listing at all? It could mean something is corrupt or it could mean your installation has a problem.

 

[CEH]

Dont use switchboard, so its no problem...... Yea, strange.... Everything works..so it IS actually linked.... Just doesn't want to show it.... Might be the reload I had to do... I'll reload Access next week... see if some corruption happened there.....

 

[CEH]

OK........ Update to this problem...... Have both Access 2002 and 2003 on this machine... Removed and reloaded both versions, suspecting something corrupt in the install... Now, I can view the linked table manager if I open the frontend with 2002, but no tables show if I open it with 2003........????