Tap into Exchange data source

[Guest]

My boss would like me to write some code to analyze usage of our Exchange
Server. I found the Exchange link in the Get External Data popup, but that
only lets me link to my mailbox.

Does anyone know how to tap into the Exchange Server data store so that I
can get more detailed information about our Exchange Server usage?

 

[Douglas J. Steele]

This newsgroup is for questions about forms in Access, the database product
that's part of Office Professional. Are you trying to get this information
using Access?

Even if you are planning on using Access, you might want to try one of the
Exchange newsgroups, such as microsoft.public.exchange.development.

 

[Dale Fye]

Yes, Doug, I am going to try to tap into it using Access. I'll take your
suggestion under advisement.

 

[John Nurick]

Hi Dale,

You won't get this information out of the Exchange data store. Instead,
set up Exchange to keep logs of the transactions you're interested in.
Then use Access to analyse the log files.

 

[Dale Fye]

John,

Don't know why, but I was under the impression that Exchange used a SQL
Server database as the backend to store all of the data. Guess that was
wishful thinking.

Dale

 

[John Nurick]

Dale,

Reasonable thinking: people have been expecting it to change to SQL
Server for years. AIUI the Exchange data store is based on the same Jet
engine that Access uses - but they're no longer compatible if they ever
were.