Where linked tables point to

K

kdw

Is there a way to find out where the linked tables are pointing to in a
front-end back-end databases? I have multiple copies of the BE database in
different places and want to be able to verify if FE points to the correct BE.

Thanks
 
R

Rick Brandt

kdw said:
Is there a way to find out where the linked tables are pointing to in
a front-end back-end databases? I have multiple copies of the BE
database in different places and want to be able to verify if FE
points to the correct BE.

Thanks
Click to expand...

Look at properties in design view of the link or examine the Connect property in
code.
 
A

Albert D.Kallal

In later versions (well at lest a2003), when you hold your mouse pointer
over any table in the tables view...the full path name shows as a tool tip.

However, while in any version of recent...just hit ctrl-g to get to the
immediate command prompt..and type in


? currentdb.TableDefs("contacts").Connect

The above on my machine returns

;DATABASE=C:\Documents and Settings\Albert\My Documents\db5_be.mdb
 
M

Mike Labosh

Is there a way to find out where the linked tables are pointing to in a
front-end back-end databases? I have multiple copies of the BE database
in
different places and want to be able to verify if FE points to the correct
BE.
Click to expand...

SELECT DISTINCT Connect, Database
FROM MSYSObjects
WHERE Type IN (4, 6)


--
Peace & happy computing,

Mike Labosh, MCSD
"Working here is like living inside a Salvador Dali painting." -- Me. Yeah,
ME! [Oh fer cryin out loud]
 
Top