Question
Linking Exchange Contacts through Access
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?
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?