go to the Access MVP home page           go to Crystal's Access Basics

ListFiles Database
by and modified by Crystal

Recursive File listing modified from code witten by Allen Browne.
Browser code originally written by Stephan Lebans.
GetComputerName written by Dev Ashish.

and, coming soon ...

a new version with code to get additional file information that is exposed by Windows 7 and Vista, written by master Wayne Phillips

Accessing detailed file information provided by the Operating System
(Windows Vista and above) by Wayne Phillips
http://www.everythingaccess.com/tutorials.asp?ID=Accessing-detailed-file-information-provided-by-the-Operating-System


      Read information about files stored on your computer and store the results in an Access database.
            Start from the root directory of a drive or specify a path.
 

Download ListFiles_080323_Crystal_090720CR.zip (208 K)  

Reads file name and file attribute information into a database -- can be done for one directory or a directory tree. NEEDS references to:

  • Microsoft Scripting Runtime (because all the information that can be obtained from the FSO object is also recorded)
  • Microsoft DAO # Object Library
    or
    Microsoft Office # Access Database Engine Object Library
This sample database can be distributed freely. If you are selling an application and wish to incorporate code or ideas, you will need to obtain written permission from all the authors.

The main benefit of this database is the data that it generates about the files stored on your computer. Any other objects such as queries and forms are probably not needed by the program unless they start with usys, which marks them as user system objects.

Best to Compile before you run. Look at Relationship diagram and Field Descriptions in each Table Design.





Comments

"May I hint you to check the underlying query for your form named "f_Showfiles". I've missed the path informations, but adding the table "Dirs" resolves that problem."

— Jens Schilling, Microsoft MVP, Access

Thank you for pointing this out, Jens ... guess I left some of my half-baked ideas in there... I never finished that form -- had great plans for it ;) Feel free to modify or just delete the f_Showfiles form

Now I have brilliant code written by Wayne Phillips that gets additional file properties that are exposed by Windows 7 and Vista such as the Date and Time a picture was taken, or the Length of an MP3 file ... so I will update this database to include these new treasures (smile).

Free Book on Access: Access Basics

Free Tutorials: Video Tutorials

for information on private programming and training, or if you have comments and ideas, I'd love to hear from you

© Copyright 2009, 2010 Crystal Long.  All rights reserved.
Last Updated:  March 1, 2010
thanks to Arvin Meyer for setting up this site and giving Access MVPs a place to share with others.

Free Hit Counter
Visitors