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 » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Changing Linked Table Path



 
 
Thread Tools Display Modes
  #1  
Old May 7th, 2009, 06:22 PM posted to microsoft.public.access
JK
external usenet poster
 
Posts: 220
Default Changing Linked Table Path

I have a split database where the back end is stored on a network drive.
Depending on the computer the network drive name can be different. For
example, I have the network drive mapped as R: when someone else can have it
mapped on their computer as the Z:. The name of the drive is actually
\\fadsf-afs.

When I split the database, the path to all the linked tables start with R:,
so when other people who mapped the drive as Z: they get an error.

How do I save the beginning of the path as \\fadsf-afs instead of R:?
  #2  
Old May 7th, 2009, 08:55 PM posted to microsoft.public.access
John Spencer MVP
external usenet poster
 
Posts: 533
Default Changing Linked Table Path

If you use the built-in Linked Table Manager tool to set links navigate to
your network places and find the server fadsf-afs and navigate down to your
database that way. When you finish linking the R: will be replaced with the
server reference \\fadsf-afs

If you use some other method to set the path, then we would need to know the
code you are using.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

JK wrote:
I have a split database where the back end is stored on a network drive.
Depending on the computer the network drive name can be different. For
example, I have the network drive mapped as R: when someone else can have it
mapped on their computer as the Z:. The name of the drive is actually
\\fadsf-afs.

When I split the database, the path to all the linked tables start with R:,
so when other people who mapped the drive as Z: they get an error.

How do I save the beginning of the path as \\fadsf-afs instead of R:?

  #3  
Old May 7th, 2009, 11:21 PM posted to microsoft.public.access
JK
external usenet poster
 
Posts: 220
Default Changing Linked Table Path

Thanks for the reply.

I tried to navigate through using the network places, however I cannot
access the folders on the server that way. The next folder down on the
server is not an option. (Ex. \\fadsf-afs\ew$) I can type that in a
windows explorer and get to the folders I need, but when I use the network
places ew$ is not an option I can select. I'm 100% positive that I am
navigating to the correct server when using network places.

I do not know how to correctly set the path using code. I'm pretty new to
writing code in Access so my knowledge on the correct syntax and where to
place the function, like when the program opens or when a form opens, is
limited. I don't even know how to run a function when the program is first
opened automatically.

If I have the people just change the path manually using the link table
manager on the front end they have on their computer, will this resolve the
issue?
  #4  
Old May 8th, 2009, 04:36 PM posted to microsoft.public.access
John Spencer MVP
external usenet poster
 
Posts: 533
Default Changing Linked Table Path

You might check out the following URL that has code to link tables.
http://www.mvps.org/access/tables/tbl0009.htm

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

JK wrote:
Thanks for the reply.

I tried to navigate through using the network places, however I cannot
access the folders on the server that way. The next folder down on the
server is not an option. (Ex. \\fadsf-afs\ew$) I can type that in a
windows explorer and get to the folders I need, but when I use the network
places ew$ is not an option I can select. I'm 100% positive that I am
navigating to the correct server when using network places.

I do not know how to correctly set the path using code. I'm pretty new to
writing code in Access so my knowledge on the correct syntax and where to
place the function, like when the program opens or when a form opens, is
limited. I don't even know how to run a function when the program is first
opened automatically.

If I have the people just change the path manually using the link table
manager on the front end they have on their computer, will this resolve the
issue?

 




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:43 PM.


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