MS Access and file or folder size

[tonyhines]

MS Access 2000
Win XP Pro

I have a report that runs in MS Access and it gives lots of locations of selected data. I'd like to grab the sizes of a few files and a few folders for that report on the fly and add it to the report.

Any ideas?

thanks,
tonyh

[FishVal]

Hello, tonyh.

Getting single file size is simple using FileLen() function.
To get size of a folder I think you will need to iterate the folder contents if the folder expected to contain nested folders. Microsoft Scripting Runtime would help you to make it easier. There are several articles about it in Howtos section.

Regards,
Fish