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

ckryshtalowych@u...



{snip}

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?

{/snip}






  Return to Index