If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do you change the link in a split database
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. |
#2
|
|||
|
|||
How do you change the link in a split database
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 "texasyankee" wrote in message ... 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. |
#3
|
|||
|
|||
How do you change the link in a split database
On Wed, 5 Aug 2009 07:58:03 -0700, texasyankee
wrote: 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. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
How do you change the link in a split database
On Wed, 5 Aug 2009 07:58:03 -0700, texasyankee
wrote: 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 |
#5
|
|||
|
|||
How do you change the link in a split database
Thanks very much. All is working fine.
"John W. Vinson" wrote: On Wed, 5 Aug 2009 07:58:03 -0700, texasyankee wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|