p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: How can I locate the source of linked tables?


Message #1 by "Darron Michael" <darron.michael@h...> on 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?



Thanks.
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Mon, 04 Jun 2001 12:06:42 -0700
Try the linked table manager--it's an add-in in A97 I believe.



Failing that, check out their .Connect properties, e.g. (from the debug

window)



?CurrentDB.TableDefs("tblMyTable").Connect



Hope that helps,



-Roy



-----Original Message-----

From: Darron Michael [mailto:darron.michael@h...]

Sent: Monday, June 04, 2001 11:56 AM

To: Access

Subject: [access] How can I locate the source of linked tables?





I inherited a Access 97 database with linked tables.  How can I find out 

where is the source of these linked tables?



Thanks.




Message #3 by pmcmillin@m... on Mon, 04 Jun 2001 13:47:53 -0500
If you have the Add-In Manager installed you go to Tools---Add-Ins---Linked 

Table Manager.  This shows you where all the linked tables reside.



At 01:56 PM 6/4/2001, you wrote:

>I inherited a Access 97 database with linked tables.  How can I find out

>where is the source of these linked tables?

>

>Thanks.






Pam McMillin

Systems Technician



Schlumberger - IPM Asset Management

500 W. Texas, Suite 500

P.O. Box 2726

Midland, TX 79702-2726

Office 915/571-4600

Cell 915/556-0749

Fax 915/571-4788

pmcmillin@m...

Message #4 by "Levine, Lloyd" <LEVINLL@m...> on Mon, 4 Jun 2001 22:42:34 -0400
Go to the tools menu and then add-in manager. There should be a linked table

manager that will show you where the link tables exist.



-----Original Message-----

From: Darron Michael [mailto:darron.michael@h...]

Sent: Monday, June 04, 2001 2:57 PM

To: Access

Subject: [access] How can I locate the source of linked tables?





I inherited a Access 97 database with linked tables.  How can I find out 

where is the source of these linked tables?



Thanks.

Message #5 by Miriam Engelberg <MiriamE@c...> on Mon, 4 Jun 2001 16:17:44 -0700
The linked table manager that others have suggested is a good way. But I

often simply double-click on the linked table to open it. The error message

states the path to the original table.



Miriam Engelberg

Technology Faculty/Chief Cartoonist

CompassPoint Nonprofit Services

www.compasspoint.org

(xxx) xxx-xxxx





-----Original Message-----

From: Darron Michael [mailto:darron.michael@h...]

Sent: Monday, June 04, 2001 11:57 AM

To: Access

Subject: [access] How can I locate the source of linked tables?





I inherited a Access 97 database with linked tables.  How can I find out 

where is the source of these linked tables?



Thanks.



Message #6 by "Darron Michael" <darron.michael@h...> on Tue, 5 Jun 2001 14:17:02
Thanks.  I knew it had to be somewhere but I hadn't found it.  ;^)



Darron

  Return to Index