Linked to what table?

[gblack]

OK,

I feel really stupid already for even thinking about asking this question... I did a search, but it was tough to find the right words for this... I know it will probably be something really simple... and make me feel really dumb for asking... but here goes:

I am going through another developer's databases and there's a linked table in one database. Said table is being linked to another database that has a bunch of tables... all similar in name and sructure...

The linked table has been renamed with an alias, which simply denotes its database name.

For example:

Let's say in a database named Wilma.accdb, there is a linked table who's alias is "FRED"

The database name, where the table resides, is FRED.accdb.

Inside FRED.accdb there are a bunch of tables that all have similar data structure and names (i.e., like Fred_Quary, Fred_Bowling, Fred_LOWB, Fred_Etc...).

When you hover over the linked table (in Wilma.accdb), it shows the path to FRED.accdb... but doesn't show the table name FRED is linked to within FRED.accdb. If you right click the table and click on table properties... only "FRED" appears as the name.

So how can I tell which table is actually being linked to, without making changes to the data in Wilma and then manually checking all the tables in FRED.accdb for those changes?

Like I said, I should probably know how to do this already, since I have only been working with Access for 14+ years... but I am at a loss because I never have had an issue like this before.

Everything has always been blatantly obvious when it comes to tables and where they are linked to...

If the answer is simple... my ego requests you make it sound profoundly difficult and overly involved... all superfluous explanations will be greatly appreciated!

Regards,
-G

PS. LOWB = "Loyal Order of Water Buffalo"

 

[KenHigg]

You should be able to do tools->options->view> and turn 'system objects' to visible and see these. I think the you are looking for the foreign name property.

 

[gblack]

In 2007?

Do you mean "database tools"?

I don't see a "tools>option"anywhere...

 

[KenHigg]

Um... Let me see where it is in 2007...

 

[KenHigg]

Try this:

http://www.techonthenet.com/access/database/view_systables2007.php

 

[gblack]

Unless I am missing something... which is entirely possible... I don't see whereas this link actually helps, as it doesn't appear to show the original table name anywhere... but like I said... I could very well be missing it.

 

[KenHigg]

It's not a column in mysysobjects table?

 

[gblack]

Yeah it sure is... under foreign name! Thanks Ken!

 

[KenHigg]

Glad you have it working

 

[Gouri Dutta]

LINKED TABLES SHOW #DELETED MESSAGE.
I have a linked database where I tried to delete the link and re-link. But all records show "#(#DELETED)". Now, whenever I open another linked table, it shows #Deleted too. This happens in Windows 2003 with ACCESS 2003, but when I open the table in Windows 7 with windows 2007 ACCESS, data look OK. Can anybody help me to resolve the problem in Windows 2003?
Many many thanks in Advance
This is a new problem. I could not post it anywhere

 

[Gouri Dutta]

LINKED TABLES SHOW #DELETED in ACCESS 2003

LINKED TABLES SHOW #DELETED MESSAGE in ACCESS 2003
I have a linked database where I tried to delete the link and re-link. But all records show "#(#DELETED)". Now, whenever I open another linked table, it shows #Deleted too. This happens in Windows 2003 with ACCESS 2003, but when I open the tables in Windows 7 with windows 2007 ACCESS, data look OK. Can anybody help me to resolve the problem in Windows 2003?
Many many thanks in Advance
This is a new problem. I could not post it anywhere

 

[gemma-the-husky]

the table in the linked database is given by

currentdb.tabledefs("ourtable").sourcetablename