By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,137 Members | 2,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,137 IT Pros & Developers. It's quick & easy.

Identifying Access Databases with tables linked from other Databases/Files

P: n/a
Hi,

Have a number of Access Databases that I inherited and want to zip a
few of them. My concern is that other active Microsoft Applications
may be linking to the database or its tables. Is there a method of
searching that will allow me to identify those MS Access files that are
linked to. I am not really concerned with itemizing the which files
link to which, but just that a link exists.

Thanks in advance for any help.

Bill

Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
It is easy to find the files which it links to but I don't know of any way
to find the files which link to it.

If you want to find the ones it links to look up the "linked table manager".

If you want it the other way round I can't think of any suggestions :(

<bi**********@grainger.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Hi,

Have a number of Access Databases that I inherited and want to zip a
few of them. My concern is that other active Microsoft Applications
may be linking to the database or its tables. Is there a method of
searching that will allow me to identify those MS Access files that are
linked to. I am not really concerned with itemizing the which files
link to which, but just that a link exists.

Thanks in advance for any help.

Bill

Nov 13 '05 #2

P: n/a
John,

Thanks for the reply. Yeah I had the linked table manager for the
databases linked to. The linked from is what I want.

Bill

Nov 13 '05 #3

P: n/a
The only way I can think of doing the reverse of what the linked table
manager does is to use DAO and loop through the tabledefs, querydefs
(and other objects) of each database in your network/computer and check
the Connection string on all the tables. You *might* have to check the
queries for somethign like "IN <database path>".
you might also have to check the hidden queries that act as rowsources
for form controls etc. Depends entirely on how complex your databases
are.

IOW, think of *all* the ways you can connect one database to another,
and then search for all references.

but I could be completely on crack.... but that's the only way to do it
that my low HP brain can come up with...

Nov 13 '05 #4

P: n/a
Hi Bill,

Look at the Connect property in the help file. Linked tables belong to a
TableDef collection in their respective databases. TdfLinked.connect gives
you a string that contains the name of the source database. You would have
to build a procedure that opens all your databases one at a time, goes to
the TableDef collection and gets the connect property of each table. You
would parse the connect string to get the source database and build a list
of non-duplicate source databases. If you were sure all the linked tables in
a database linked to the same database, you would only need to go to one
linked table to get the source database.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<bi**********@grainger.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
Hi,

Have a number of Access Databases that I inherited and want to zip a
few of them. My concern is that other active Microsoft Applications
may be linking to the database or its tables. Is there a method of
searching that will allow me to identify those MS Access files that are
linked to. I am not really concerned with itemizing the which files
link to which, but just that a link exists.

Thanks in advance for any help.

Bill

Nov 13 '05 #5

P: n/a
bi**********@grainger.com wrote:
Hi,

Have a number of Access Databases that I inherited and want to zip a
few of them. My concern is that other active Microsoft Applications
may be linking to the database or its tables. Is there a method of
searching that will allow me to identify those MS Access files that are
linked to. I am not really concerned with itemizing the which files
link to which, but just that a link exists.


As others have suggested you'd have to crawl through the network
directories and find all database, then check their Connect property of
any tabledef. It's perfectly doable (if you have the knowledge of DAO
to do it).

OTOH, the only thing you'd have to be certain of is that no one has a
local copy or another database on their PC drive(s). There's no way to
find those (without getting people mad at you for searching their local
drives).

Nov 13 '05 #6

P: n/a
pi********@hotmail.com wrote:
The only way I can think of doing the reverse of what the linked table
manager does is to use DAO and loop through the tabledefs, querydefs
(and other objects) of each database in your network/computer and check
the Connection string on all the tables. You *might* have to check the
queries for somethign like "IN <database path>".


I haven't got a clue how to do it, but shouldn't any active links
initiate the locking ldb file? I know there's ways and methods out on
the net and possibly at the Access Web for determining users via an ldb,
so I wonder if it's possible to do something similar to find what apps
are currently hitting the mdb?

I know in Oracle, I use v$_Session for this.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #7

P: n/a
"ac*******@railvan.com" <ac*******@railvan.com> wrote in
news:11*********************@g49g2000cwa.googlegro ups.com:
bi**********@grainger.com wrote:

Have a number of Access Databases that I inherited and want to
zip a few of them. My concern is that other active Microsoft
Applications may be linking to the database or its tables. Is
there a method of searching that will allow me to identify those
MS Access files that are linked to. I am not really concerned
with itemizing the which files link to which, but just that a
link exists.


As others have suggested you'd have to crawl through the network
directories and find all database, then check their Connect
property of any tabledef. It's perfectly doable (if you have the
knowledge of DAO to do it).

OTOH, the only thing you'd have to be certain of is that no one
has a local copy or another database on their PC drive(s).
There's no way to find those (without getting people mad at you
for searching their local drives).


Well, you'd also want to check the LDB files on the server (using
LDBUSR.DLL or ADO UserRoster). That would at least tell you which
workstations had the MDB files open.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.