database split

[AccessMan]

I recently split a database with a large number of tables, but I fear that I
did not properly specify the location of the back end. Linked Table Manager
reveals that a local path was specified (C:\Documents and Settings\ ...)
rather than a UNC path. How can I update this path so that the front ends
can find the back end?

Thanks!

 

[Tom van Stiphout]

On Tue, 22 Jan 2008 17:44:13 -0800, AccessMan

Depends on your version of Access. Check the help file for "Linked
Table Manager".

-Tom.

 

[John W. Vinson]

I recently split a database with a large number of tables, but I fear that I
did not properly specify the location of the back end. Linked Table Manager
reveals that a local path was specified (C:\Documents and Settings\ ...)
rather than a UNC path. How can I update this path so that the front ends
can find the back end?

Thanks!

Use Tools... Database Utilities... Linked Table Manager. Select all the tables
and check the "always prompt for new location" checkbox, then click OK.

Navigate to the backend *using Network Neighborhood* (or My Network Places or
whatever cute name your version of Windows prefers), rather than through My
Computer. It will save the link as a UNC path.

John W. Vinson [MVP]