Changing the properties of a Linked table

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

John Nurick

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