How to find location of a linked table in Access 97

[ziggs]

I have a few DB's that I inherited. One Access database 97 is working
fine and on our network and is the front end to another access 97 db
within an unknown network folder. But, here's the question. When I
look in the table area, I see three linked tables. How can view the
link table and determine where the back end Access 97 is?

TIA

[Dennys G.]

1.. Open your database in design mode.
2.. Click on Add-Ins in the Tools Menu.
3.. Click on the "Linked Table Manager" in the Add-Ins. (Hopefully, this was installed. If not, you will need to install it.)
4.. In the Linked Table Manager, you should see all the tables and the paths to the back-end database.
Denny G.
"ziggs" <zi***@hotmail.com> wrote in message news:ub********************************@4ax.com...

I have a few DB's that I inherited. One Access database 97 is working
fine and on our network and is the front end to another access 97 db
within an unknown network folder. But, here's the question. When I
look in the table area, I see three linked tables. How can view the
link table and determine where the back end Access 97 is?

TIA

[Terry Kreft]

....
If you can't read the path there then in the debug window (Ctrl+G) type

?Access.Currentdb.Tabledefs("NameOfYourTableHere") .Connect

and hiit enter.
Terry

"Dennys G." <gi*****@adelphia.net> wrote in message news:Bl*********************@news3.news.adelphia.n et...
1.. Open your database in design mode.
2.. Click on Add-Ins in the Tools Menu.
3.. Click on the "Linked Table Manager" in the Add-Ins. (Hopefully, this was installed. If not, you will need to install it.)
4.. In the Linked Table Manager, you should see all the tables and the paths to the back-end database.
Denny G.
"ziggs" <zi***@hotmail.com> wrote in message news:ub********************************@4ax.com...

I have a few DB's that I inherited. One Access database 97 is working
fine and on our network and is the front end to another access 97 db
within an unknown network folder. But, here's the question. When I
look in the table area, I see three linked tables. How can view the
link table and determine where the back end Access 97 is?

TIA

[Christine Whiteside]

Tools:Addins:Linked Table manager...

HLH

Tom.
"ziggs" <zi***@hotmail.com> wrote in message
news:ub********************************@4ax.com...

I have a few DB's that I inherited. One Access database 97 is working
fine and on our network and is the front end to another access 97 db
within an unknown network folder. But, here's the question. When I
look in the table area, I see three linked tables. How can view the
link table and determine where the back end Access 97 is?

TIA