Linked Table Properties

  • Thread starter Thread starter Danu
  • Start date Start date
D

Danu

Help please.

A number of users access the same database. There is a linked table in the
database which is linked as "S\folder\subfolder\database.mdb. However, not
all the users can access "S". I need to use the entire address which would be
\\server\folder\subfolder\database.mdb.

Each time I try to change the address in the properties field of the linked
table, it defaults back to the original address using "S". Where else can I
change to the full address so that all users can access the linked table.

Thanks in advance.
 
hi Danu,
Each time I try to change the address in the properties field of the linked
table, it defaults back to the original address using "S". Where else can I
change to the full address so that all users can access the linked table.
Click to expand...
You need to recreate the links using the UNC path.


mfG
--> stefan <--
 
You can't just change it through the Properties window. You either need to
use the Linked Table Manager (and navigate to the back-end using the Network
Neighborhood, rather than using the mapped drive), or else do it using VBA
code.
 
Thanks! This seems to have done the trick.

Douglas J. Steele said:
You can't just change it through the Properties window. You either need to
use the Linked Table Manager (and navigate to the back-end using the Network
Neighborhood, rather than using the mapped drive), or else do it using VBA
code.
Click to expand...
 
Back
Top