Here's a little function I've used quite often to check linked tables and their
sources. I actually use this function (in a slightly modified version) to
populate a report that I can then print and review at my leisure.
Here's the code:
Dim db As Database
Dim tdf As TableDef
Set db = CurrentDb()
For Each tdf In db.TableDefs
Remember, you've got to have the Debug window opened before you run this
function (ctrl-g will open it up for you).
Hope this helps!
Systems Specialist/Boy Genius
University HealthCare Systems
Subject: How can I locate the source of linked tables?
From: "Darron Michael" <darron.michael@h...>
Date: Mon, 4 Jun 2001 18:56:34
I inherited a Access 97 database with linked tables. How can I find out
where is the source of these linked tables?