A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do you change the link in a split database



 
 
Thread Tools Display Modes
  #1  
Old August 5th, 2009, 03:58 PM posted to microsoft.public.access.tablesdbdesign
texasyankee
external usenet poster
 
Posts: 14
Default 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  
Old August 5th, 2009, 04:10 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
Old August 5th, 2009, 05:13 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old August 5th, 2009, 06:48 PM posted to microsoft.public.access.tablesdbdesign
Armen Stein
external usenet poster
 
Posts: 507
Default 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  
Old August 5th, 2009, 07:13 PM posted to microsoft.public.access.tablesdbdesign
texasyankee
external usenet poster
 
Posts: 14
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.