Linked tables & UNC

  • Thread starter Thread starter Mark
  • Start date Start date
M

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??
 
hi Mark,
How can I ensure every time they go into my db app that the db app finds the
linked tables??
Click to expand...
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 said:
How do I use UNC to link the tables in the first place? Do I need to
write
some code?
Click to expand...

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)
 
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
 
Back
Top