Finding the backend tables for a front end ?

[Isis]

I have an mdb which is a front end using an odbc connection to read and
write some back end tables (non access). If I open the linked Table
manager I can see the varios tables listed (the remote ones) with entries
like;

SubsTable (DSN=New, Database=dialler)
MemNum (DSN=New, Database=dialler)
NewNum (DSN=New, Database=dialler)


I am assuming that the file (?) 'dialler' is a container (SQL ?) of
tables ?

Now I want to know exactly where (which PC and folder) the 'dialler' file
is in - how do I do this ?

I don't see any direct references to paths etc - I have had a quick look
in the Control Panel | Administrative Tools | Data Sources (ODBC) - where
do I find this information please.

Thanks

 

[Douglas J. Steele]

See my June, 2004 (and possibly my July, 2004) "Access Answers" column in
Pinnacle Publication's "Smart Access"

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[John Spencer]

You will have to examine the DSN to find out any information on the location.

If you open Data Sources (ODBC) and double click the DSN "NEW" and step
through clicking on the next buttons until you get to a screen with a TEST
DATA SOURCE... button, you will see the Server name. This may or may not tell
you where the information is stored.

PRESS the CANCEL button to exit and not save a new source or overwrite the
existing source.



John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Isis]

http://www.accessmvp.com/DJSteele/SmartAccess.html

Douglas,

Thanks for the links - I have read (at speed) both articles - am I right in
thinking that ther is no way to tell where the tables are except to add vb
code to the front end I have to get the locations ?

Thanks

 

[Douglas J. Steele]

Douglas,

Thanks for the links - I have read (at speed) both articles - am I right
in
thinking that ther is no way to tell where the tables are except to add vb
code to the front end I have to get the locations ?

Not really. If all you want is to know where a specific table is pointing,
you can always go to the Immediate Windows (Ctrl-G) and type

?CurrentDb().TableDefs("NameOfTable").Connect

and see what it says. Of course, you have no way of knowing if all the
linked tables are pointing to the same data source.