p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

access thread: Re: How can I locate the source of linked tables? (some code)

Message #1 by "Chris Kryshtalowych" <ckryshtalowych@u...> on Tue, 5 Jun 2001 08:58:29 -0400

Hi Darron,

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:

   Function tableLinks()

      Dim db As Database

      Dim tdf As TableDef

      Set db = CurrentDb()

      For Each tdf In db.TableDefs

         Debug.Print tdf.Connect

      Next tdf

   End Function

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!

Chris Kryshtalowych

Systems Specialist/Boy Genius

University HealthCare Systems

Augusta, Georgia



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?


  Return to Index