On January 8, 2014 at 1:01:41 PM, Liz Ravenwood (liz_ravenwood@beaerospace.com) wrote:
If you create a new db and import the tables by selecting all in to the new db – just as a test you'll get notification on all your bad links.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of James McAlister
Sent: Wednesday, January 08, 2014 11:52 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Locating wrong paths for linked tables.
James
www.james-mc.com
Words To Live By
I'm using Access 2010 and have a number of linked tables (mostly Excel files but at least one Access file). I've made some changes in directory structure, and that broke the links to several of the linked tables. I can visually spot a bad one by hovering the mouse cursor over a table's icon in the sidebar, which pops up the path, but I'm wondering if there's a better way to identify which ones have broken links since there's no error given when I run the a query that involves the linked table.
I've been fixing the broken links (with the linked table manager) as I find them but would appreciate suggestions for a more efficient way to handle that as well.
Hopefully this is clear.
Thanks for any pointers.
——
James
www.james-mc.com
Words To Live BySent from Airmail app on Mac
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar