By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,060 Members | 1,198 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,060 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?

Sep 17 '08 #1
Share this Question
Share on Google+
1 Reply

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.

Sep 17 '08 #2

Post your reply

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