database split

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AccessMan - 23 Jan 2008 01:44 GMT

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!

Reply to this Message

Tom van Stiphout - 23 Jan 2008 04:35 GMT

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

-Tom.

>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
[quoted text clipped - 3 lines]
>
>Thanks!

Reply to this Message

John W. Vinson - 23 Jan 2008 05:47 GMT

>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
[quoted text clipped - 3 lines]
>
>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]

Reply to this Message