Linking Exchange Contacts through Access

[DenonSix]

I have been trying to access exchange contact information by:

1) Linking Outlook Data to an Access MDB
2) Setting up the MDB as a Coldfusion datasource

The problem is, once I move the mdb to the exchange server, the mapi folder
'no longer exists'. I believe this is because they are relative to where the
mdb file was set up (unfortunately if you set it up on the exchange server it
still screws up since outlook and exchange are finiky together on the same
machine. If I run the cfm it comes back with an error telling me that no mapi
client is installed even though Outlook 2003 is on the server).

Has anyone successfully accessed exchange contact data through access? I was
thinking about setting it up locally and then using an odbc on the server to
access a remote shared file. The key is for Coldfusion to use a truly remote
mdb so that it is not manipulated by the server However, i'm not sure if
there's a better way. Any ideas?

[elDonrico]

why dont you try using cfldap instead...

<cfldap server = "server_name"
port = "port_number"
username = "name"
password = "password"
action = "action"
name = "name"
timeout = "seconds"
maxRows = "number"
start = "distinguished_name"
scope = "scope"
attributes = "attribute, attribute"
filter = "filter"
sort = "attribute[, attribute]..."
sortControl = "nocase" and/or "desc" or "asc"
dn = "distinguished_name"
startRow = "row_number"
modifyType = "replace" or "add" or "delete"
rebind = "Yes" or "No"
referral = "number_of_allowed_hops"
secure = "multi_field_security_string"
separator = "separator_character"
delimiter = "delimiter_character">



<a target=_blank class=ftalternatingbarlinklarge
href="http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p69.htm">http:
//livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p69.htm</a>

[DenonSix]

Will that work? All I have on this machine is Exchange 2k3 and all these contacts are external contacts (in a public folder in outlook - not in AD)

[elDonrico]

well, i guess it really isnt that possible as of right now... <a target=_blank
class=ftalternatingbarlinklarge
href="http://www.forta.com/blog/index.cfm/2005/12/9/ColdFusion-Exchange-Integrat
ion">[url]http://www.forta.com/blog/index.cfm/2005/12/9/ColdFusion-Exchange-Integrati[/url]
on</a> here is a discussion thread on the subject started by forta...
but, if you can manage to access it from

<a target=_blank class=ftalternatingbarlinklarge
href="http://www.ldapbrowser.com/download/index.php">[url]http://www.ldapbrowser.com/[/url]
download/index.php</a>

that, you should be able to query it like any other datasource...

[DenonSix]

Unfortunately I can see the public folder with the contact in it, but not the
actual contact information using that browser....

Has anyone found a way to use an access database from a web application where
the access database is linked to exchange data?