[AccessD] Linked Tables - UNC Path

? By "no user intervention", then you are linking before distribution?

If you are setting the links, then, in Linked Table Manager, browse to
the BE by first going to Network Neighborhood, then find the
server\share\folder.  Then, your FE will have UNC links.

If the user is going to select the BE, then you will need the re-linking
code, plus the API call to MPR.dll as suggested earlier, to convert the
mapped drive to UNC ... You should probably use API for CommonDialog for
this method as well, to avoid ocx issues.

Hth
Steve


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mitsules,
Mark S. (Newport News)
Sent: Friday, May 07, 2004 9:24 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Linked Tables - UNC Path


Lol.  I apologize...I think you're making the assumption that I have
existing relinking code already in place...I don't:(  This my first time
at a TRULY multi-user app.  Maybe I need to be walked through this, but
the built-in linked table manager appears to use drive-letter mappings,
not UNC. If I deploy the front-end to a person who doesn't have the same
drive-letter mappings, I get an error.  What I was looking for was an
approach that (1)mimics published relinking code, such as
http://www.mvps.org/access/tables/tbl0009.htm,  (2)forces UNC naming,
yet (3)doesn't include possible user intervention.


Mark


-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Friday, May 07, 2004 9:05 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Linked Tables - UNC Path


Hi Mark

Hmmm .. I'm not sure I can follow you here - if you have the UNC path it
doesn't matter wether the user has a drive mapped to it or not. You just
need to relink with the UNC path. But why relink if you have deployed
the app linked to the UNC path of your choice?

/gustav


> Actually my situation is just the opposite.  I know the remote server
name,
> but the user may have that drive mapped to any letter.  Therefore I 
> would like to be able to relink automatically using UNC.  I am not 
> comfortable with the user manually choosing the location of the BE.

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com