Browsing to a folder

[Pastor Del]

My application is Access 2000, located on a network server and is run from
multiple computers by Access 2000, 2003, 2007. It progarmmatically logs onto
a network account using the server's IP address. I use the IP address
because the user's computer is logged on using its name and I need an account
with more rights. This all works well for programmatically maintaining files
in the secure folders but I also need to allow certain users of my
application to browse to the secure folders through my applicaiton. I cannot
make BrowseFolder ("") work because I'm logged on using the server's IP
address instead to the computer's name. Can anyone help me with this dilemma?

 

[DW]

Pastor Del,

If it is on an internal network, you might be able to try using the UNC
instead of the IP address. If the application is referencing files in a
particular folder, the security settings of the application alone will not
suffice; Security settings would need to be set on the parent folder which
contains the files the users need to locate. Add all necessary users under
the parent folder's security settings, specifically allowing those who need
access. Let me know if this helps you.

 

[Pastor Del]

Let me put this differently. When my application opens a browse window with
BrowseFolder and the user selects a folder from the network it returns a path
to that folder. Is there a way to only get the full path back instead of a
mapped drive path?

 

[John Spencer]

There is code for
Enumerating Local and Network Drives
at
http://www.mvps.org/access/api/api0003.htm

One section of the code will return the UNC path of a drive given the drive
letter. You can use that to get the UNC path to the drive and then replace
the drive letter in with the UNC path to the drive.

Author(s)
Dev Ashish & Terry Kreft
(Q) Is there a way that I can return all available local drive letters, and
return the UNC path of any network connections that the computer might have??

Use the sample sub sListAllDrives as an example on how to recurse through the
drives list. Post the following code in a new module.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Pastor Del]

This is great. I think I can get what I need from this