Display Contents of a Folder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an MS Access 2000 application that I would like to be able add a form
that will display the contents of a folder that is on a shared network. The
user needs to be able to open the files displayed from the MS Access form.

Does anyone have any suggestions on how this can be done?

Thanks in advance!

Dwight
 
Look in VBA help for the Dir function. It has some good examples, and you
can do what you are after with it.
 
That will work, but is pretty crude.
First, there is the issue of network security settings. Regardless of how
you set your macro security in Access, the network's security will override
it.
Also, You can't filter the content of the directory.
You can't control whether subdirectories are visible or can be accessed.

But, if all the OP is after is to provide a way to get to Windows Explorer,
it is a good solution.
 
Back
Top