available free space of shared network folder with quota

[jonnycakes]

Hello Bytes,

My Goal: In Access with VBA, I need to return the amount of available freespace of a shared network folder that has a quota.

In case that it matters, I want to point out that i'm working out of MS Access 2000.

Example: X:\SharedDrive1\Folder1\ In this case I would want to know the available space that Folder1 has.

It's important to know that SharedDrive1 and/or Folder1 may change (quotas will be different).

I've tried using the GetDiskFreeSpaceEx method (http://support.microsoft.com/kb/225144) and i'm finding that it is taking quotas into consideration, but only at the drive level and not at the folder level.

I've found a couple of solutions that may work, but I cant seem to figure out how to use them in Access.. These solutions can be found here: http://social.msdn.microsoft.com/For...8-b2c4df6646b4

I would like to stay away from adding an additional reference to my database if possible, but beggers cannot be choosers, so please dont let that discourage you from responding.

Any ideas out there?

Thank you in advance for your time,
Jon

[jonnycakes]

Turns out that there's a known "bug" with SMB 1.0. My issue would be corrected if I had SMB 2.0. More information can be found here: http://blogs.technet.com/b/filecab/a...26/458221.aspx
And here:
http://social.technet.microsoft.com/...-40f3358472c5/
Hope this helps somebody out there.