Linked tables and mapped drives

[SusanV]

Users occasionally lose or change their mappings, and I've replaced
everything in the modules with the UNC, but can't seem to figure how to
change the linked tables other than to remove and re-add them to the
database, and there are dozens of relationships to these linked tables...

Is there any way to change a linked table originally created via a mapped
drive to a UNC, either via the GUI or programmatically?

TIA,

SusanV

 

[Joan Wild]

Is there any way to change a linked table originally created via a mapped
drive to a UNC, either via the GUI or programmatically?

Tools, Database Utilities, Linked Table Manager. Be sure to check the
'always prompt for new location' checkbox. Then find the backend file using
Network Neighborhood; that'll use UNC mapping.

 

[SusanV]

Thank you SO much! I never noticed that option - saved me SO much work!!

;-)

SusanV