NT File Structure as a Data Source

[cratho]

Anyone familiar with using an NT file structure as a data source in Access? I am trying to store information in an Access table and query it. For example, a particular server has a particular folder with 45 files. I need to see the folder name and each file with the file name, size, last modifed date, etc... (right click, properties). I'm not sure if it is possible, but the info is there somewhere, I just need it in a table so that I can join to another db for reports, etc.........

Thanks!

 

[PHV]

Take a look at the Scripting.FileSystemObject object.
You hate to reference the Microsoft Scripting Runtime.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244