By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,996 Members | 884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,996 IT Pros & Developers. It's quick & easy.

MS Access and file or folder size

P: 1
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
Sep 17 '08 #1
Share this Question
Share on Google+
1 Reply


FishVal
Expert 2.5K+
P: 2,653
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
Sep 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.