linked tables in back end (1 Viewer)

[jetson]

I can't remember how to change the linked tables on a network share from drive letter to UNC for distribution.

I remember being able to find a way to edit the links in 97. Either that or I'm a complete idiot - which is more likely the case.

Thanks in Advance

 

[Robert Dunstan]

Hi there,

In your front end you need to use the 'Linked Table Manager' which is found in Tools---->Database Utilities---->Linked Table Manager (Access 2002). If you select all tables and check 'Prompt for New Location' then in the next dialog box in 'Open File' you can put then UNC full path name to the back end tables

i.e. \\YourServerName\FolderName\DatabaseName.mdb

That should do it for you!

HTH
Rob

 

[jetson]

Perfect Rob!

I just didn't realize I could type the UNC directly in the file field of the dialog box!

Now I can distribute this thing on time.

Thanks