Access Query To Find Size, Number of Items and Storage Limits in Exchange 2007 Mailboxes

Is it possible to use Microsoft Access 2010 to query the size, number of items and storage limits for each mailbox on an Exchange 2007 server?
Who is Participating?
ssmith81Connect With a Mentor Commented:
Hi Scam,
Please check this MS-Exchange link to get the mailbox statics in exchange 2007.

Hope, this helps you.
bbaoIT ConsultantCommented:
seems not able to do that.

Access is not listed as a supported dev environment here in the MSDN documentation.

Exchange 2007 SDK - Development Environment
ScamquistAuthor Commented:
ssmith81.  Thanks for the ideas.  The MS-Exchange link says to use the exchange shell and the command:


When I use this I get the error:
[PS] C:\Users\steven.xxxx\Desktop>Get-MailboxStatistics
Get-MailboxStatistics : Failed to commit the change on object "TEXCHANGE2007\St
andard Storage Group\Standard Storage Database" because access is denied.
At line:1 char:22
+ Get-MailboxStatistics <<<<
    + CategoryInfo          : NotSpecified: (0:Int32) [Get-MailboxStatistics],
    + FullyQualifiedErrorId : 43402815,Microsoft.Exchange.Management.MapiTasks

I am the administrator.  Any ideas.  I googled around and did not see a solution.
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

ScamquistAuthor Commented:
Found it.    on the Exchange Management Shell,  right-click on it and choose “Run as Administrator

ssmith81 - thanks
ScamquistAuthor Commented:
I appreciate the assist.
Hi Scam,
I am sorry I was not in touch with you to assist further.
But I am glad to see that you searched and find the exact solution here.
Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.