In Access 2003 how to see linked table path

[Zilla]

Hi

I am using Access 2003 and when i select a table the full link path appears below the table. ( screen shot )

How can I bring that path up so I can copy the full path and email to someone. I know there is a way where you can bring up the table properties and view it but I cant figure out how to do that.

If anyone can help please let me know.

Thanks


http://imageshack.us/photo/my-images/863/pathf.png/

 

[boblarson]

This query will return your table name and path so you can figure out how you want to make it work for you:

SELECT MSysObjects.Name, MSysObjects.Database
FROM MSysObjects
WHERE (((MSysObjects.Type)=6));

 

[zilla37]

Hi Bob

I am a newb when it comes to access.
Where would I enter the code you provided?

 

[SydneyGeek]

Select the code Bob gave you.
Create a new query in Design view. When the table list comes up, don't select any tables -- just close the dialog.
At the left of the toolbar you should see a SQL button. Click that, paste Bob's code, then display the query result by clicking the Datasheet view.

Denis

 

[zilla37]

Ok I understand that. I will try and let you know how I make out. Thanks to you both.

 

[boblarson]

Select the code Bob gave you.
Create a new query in Design view. When the table list comes up, don't select any tables -- just close the dialog.
At the left of the toolbar you should see a SQL button. Click that, paste Bob's code, then display the query result by clicking the Datasheet view.

Denis

Thanks Denis for posting that.

 

[zilla37]

Hi

The person at work finally got back to me and showed me the way he does it.

Open the access file then go Tools->Analyze->Documenter You will see tabs for forms, reports, tables,
etc. go to Tables. Select the tables you want to see, then click OK.

These tables will show as a report, print them (if you want them).

This is actually all I need is a screen shot of the path.

I do appreciated everyone's response.
Thanks again