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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|