Linking a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am linking a excel workbook to my database. My problem is that, this linked
file is on the server. My drive letter is z:
If someone else tries to use this database and if the drive letter is
different then the database does not work.
I know the server address like \\rt002 etc.
But I could not find a way to change the address of the linked table. So
some users have a problem when using the database.

Does anyone know how I can solve this problem..

thanks
 
Jack said:
I am linking a excel workbook to my database. My problem is that, this linked
file is on the server. My drive letter is z:
If someone else tries to use this database and if the drive letter is
different then the database does not work.
I know the server address like \\rt002 etc.
But I could not find a way to change the address of the linked table. So
some users have a problem when using the database.

Does anyone know how I can solve this problem..
Click to expand...

Delete the link and then recreate it only this time go through Network
Neighborhood - Entire Network to navigate to the file. Then your link will
use the UNC path \\rt002 for the link instead of the mapped drive letter.
 
Back
Top