[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 By

Sent from Airmail app on Mac

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___