Change from Drive letter location to server

[Guest]

I have a database that has been split. the backend is located on a given
drive 'U' and I would like to change that to the \\server. How do I go about
this? This is all in version 2003.

 

[Arvin Meyer [MVP]]

\\ServerName\FolderName1\FolderName2\FileName

 

[Guest]

Select the Tools, Database Utilities, Linked Table Manager from the Access
main menu.

Click the "Select All" button on the right side of the dialog box, and check
the "Always prompt for new location" checkbox at the bottom left of the
dialog box.
Then click OK.

When the "Open Form "dialog box comes up, type your network path into the
FileName combo box and click the Open button.

HTH
Dale

 

[John W. Vinson]

I have a database that has been split. the backend is located on a given
drive 'U' and I would like to change that to the \\server. How do I go about
this? This is all in version 2003.

One relatively easy way is to use Tools... Database Utilities... Linked Table
Manager; select all the tables and check the "always ask for a new location"
checkbox; and navigate to the backend *using Network Neighborhood* rather than
My Computer. This will insert the \\server\ syntax rather than the mapped
drive letter.

John W. Vinson [MVP]