Changing the properties of a Linked table

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

I currently have a database using 3 linked tables. The
link is to another Access database on the C drive. I would
like to modify the link so the database can be accessed by
remote PC's where the drive is not neccessarily C.
In other words, change "C:/access/specials.mdb"
to "/access/specials.mdb"

Thanks!
 
Hi Brad,

You can't do that, but you can use UNC paths in the form
\\COMPUTER\SHARE\Folder\file.mdb
where COMPUTER is the name of the computer on the network, and SHARE is
the name under which the drive or folder is shared.

I currently have a database using 3 linked tables. The
link is to another Access database on the C drive. I would
like to modify the link so the database can be accessed by
remote PC's where the drive is not neccessarily C.
In other words, change "C:/access/specials.mdb"
to "/access/specials.mdb"

Thanks!
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top