Linked tables & UNC

[Mark]

Hello,

I have a db that works great - the only problem is with linked tables. It is
a split db and only a very small no of users (5).

They all have differences in their pc setup, so I can't always rely on a
network drive mapping.

Some of my code does use UNC, so that's never a problem.

How can I ensure every time they go into my db app that the db app finds the
linked tables??

 

[Stefan Hoffmann]

hi Mark,

How can I ensure every time they go into my db app that the db app finds the
linked tables??

I never had any problems with using an UNC path for all linked tables.
Once the tables are linked, the UNC path should stay invariant.


mfG
--> stefan <--

 

[Mark]

How do I use UNC to link the tables in the first place? Do I need to write
some code?

 

[Douglas J. Steele]

How do I use UNC to link the tables in the first place? Do I need to
write
some code?

When you're linking the table in the first place or using the Linked Table
Manager to change the linkage, don't select the back-end database via a
mapped drive. Instead, find it through the Network Neighborhood (or whatever
it's called in the version of Windows you're using)

 

[Stefan Hoffmann]

hi Mark,

How do I use UNC to link the tables in the first place? Do I need to write
some code?

Yes, basically something like

http://www.mvps.org/access/tables/tbl0009.htm

and set strDBPath to your UNC path.


mfG
--> stefan <--

 

[Ron2006]

If you are using the re-link wizard to do the re-linking, type in the
first part of the UNC address instead of selecting a letter.

ie. \\selecteddomain\selectedserver
\etcasneededtogettopartofthenormalmapping

and then press enter, it will then operate just as if you had selected
a letter mapping.

Once that is done it will stay that way.

Ron