How do you change the link in a split database

[texasyankee]

edI created a database on my local drive. I then copied it to a network drive
and split the database. On the network drive, I have a folder called TeamDB
and within that folder is my mdb file, a folder called Data with the split
data file, and a backup foler.

When I open Linked Table Manager, the link path for all the tables is to my
local drive. How do I change the table links to the network data file?

I have a few users who can't access the DB because of this.

 

[Jeff Boyce]

I believe there's a way to tell Access to use a new path. If your users
have different "shares" (i.e., some use the "P:\" share to connect to that
network location, others use the "N:\" share, etc.), you will still not be
able to get everyone connected.

Instead, use the Network and navigate to the file that holds the back-end
data. That way, the "UNC" connection will look something like:
\\servername\folder\subfolder\... and everyone's PC will be able to connect.

Note that the location on the LAN must give the users Read/Write
permissions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

edI created a database on my local drive. I then copied it to a network drive
and split the database. On the network drive, I have a folder called TeamDB
and within that folder is my mdb file, a folder called Data with the split
data file, and a backup foler.

When I open Linked Table Manager, the link path for all the tables is to my
local drive. How do I change the table links to the network data file?

I have a few users who can't access the DB because of this.

Select all the tables in Linked Table Manager, and check the option "Always
ask for a new location" if you still have a copy of the backend on your PC.

Navigate to the backend Data folder by going all the way up to Network
Neighborhood and back down to Data, and select the backend.

One comment - you should emphatically *NOT* be letting all the users share the
same frontend (from Data). Instead, each user should have *their own copy* of
the database, all linked to the shared backend.

 

[Armen Stein]

edI created a database on my local drive. I then copied it to a network drive
and split the database. On the network drive, I have a folder called TeamDB
and within that folder is my mdb file, a folder called Data with the split
data file, and a backup foler.

When I open Linked Table Manager, the link path for all the tables is to my
local drive. How do I change the table links to the network data file?

I have a few users who can't access the DB because of this.

To add to Jeff & John's suggestions:

If you want a more automated approach to relinking tables, you're
welcome to use our free J Street Access Relinker at:
http://www.jstreettech.com/downloads

It handles multiple Access back-end databases, ignores ODBC linked
tables, and can automatically and silently relink to back-end
databases in the same folder as the application (handy for work
databases or single-user scenarios). There's a ReadMe table with
instructions.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[texasyankee]

Thanks very much. All is working fine.

Select all the tables in Linked Table Manager, and check the option "Always
ask for a new location" if you still have a copy of the backend on your PC.

Navigate to the backend Data folder by going all the way up to Network
Neighborhood and back down to Data, and select the backend.

One comment - you should emphatically *NOT* be letting all the users share the
same frontend (from Data). Instead, each user should have *their own copy* of
the database, all linked to the shared backend.