|
 |
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
|
|
|
View Cart
