Linked Table Properties

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

 

[Stefan Hoffmann]

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.

You need to recreate the links using the UNC path.


mfG
--> stefan <--

 

[Douglas J. Steele]

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.

 

[Danu]

What is "the UNC path"?

hi Danu,

You need to recreate the links using the UNC path.


mfG
--> stefan <--

 

[Danu]

Thanks! This seems to have done the trick.

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.

 

[Stefan Hoffmann]

hi Danu,

What is "the UNC path"?

UNC is the abbreviation fo Universal Naming Convention:

\\serverOrIp\share\path[\file]


mfG
--> stefan <--