Why can't I see all the data fields in Exchange when I link from MS Access?

19 Jan 2009 4:22 PM

Kelvin

I'm trying to create a report in MS Access based on the user information in
Exchange 2007.
Below are the only fields I seem to be able to see. The table shows as
"Global Address List".

Is there a way to see the rest of the data fields?

Can someone point me in the right direction?

Thanks

Kelvin

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

First
Last
Title
Company
Department
Office
Post Office Box
Address
City
State
Zip code
Country
Phone
Mobile Phone
Pager Phone
Home2 Phone
Assistant Phone Number
Fax Number
Telex Number
Display name
E-mail type
E-mail address
Alias
Assistant
Send Rich Text
Primary

19 Jan 2009 5:34 PM

Mark Arnold [MVP]

Show quote Hide quote

On Mon, 19 Jan 2009 10:22:39 -0600, "Kelvin" <some***@domain.com>
wrote:

>I'm trying to create a report in MS Access based on the user information in
>Exchange 2007.
>Below are the only fields I seem to be able to see. The table shows as
>"Global Address List".
>
>Is there a way to see the rest of the data fields?
>
>Can someone point me in the right direction?
>
>Thanks
>
>Kelvin
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>First
>Last
>Title
>Company
>Department
>Office
>Post Office Box
>Address
>City
>State
>Zip code
>Country
>Phone
>Mobile Phone
>Pager Phone
>Home2 Phone
>Assistant Phone Number
>Fax Number
>Telex Number
>Display name
>E-mail type
>E-mail address
>Alias
>Assistant
>Send Rich Text
>Primary
>

Exchange? These are Active Directory fields. Are you looking up the
right attributes?

19 Jan 2009 6:04 PM

Kelvin

Well that would explain why I can't see them.

Thanks

Show quoteHide quote

"Mark Arnold [MVP]" <m***@mvps.org> wrote in message
news:dce9n4p9u77dr4k5ob0euvn008irgb29b3@4ax.com...
> On Mon, 19 Jan 2009 10:22:39 -0600, "Kelvin" <some***@domain.com>
> wrote:
>
>>I'm trying to create a report in MS Access based on the user information
>>in
>>Exchange 2007.
>>Below are the only fields I seem to be able to see. The table shows as
>>"Global Address List".
>>
>>Is there a way to see the rest of the data fields?
>>
>>Can someone point me in the right direction?
>>
>>Thanks
>>
>>Kelvin
>>
>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>>First
>>Last
>>Title
>>Company
>>Department
>>Office
>>Post Office Box
>>Address
>>City
>>State
>>Zip code
>>Country
>>Phone
>>Mobile Phone
>>Pager Phone
>>Home2 Phone
>>Assistant Phone Number
>>Fax Number
>>Telex Number
>>Display name
>>E-mail type
>>E-mail address
>>Alias
>>Assistant
>>Send Rich Text
>>Primary
>>
>
> Exchange? These are Active Directory fields. Are you looking up the
> right attributes?