Can't select data from Access Linked Table to Exchange Public Fold



Hi All,

Although I've logged this under Access ADP SQL, it should be Access MDB SQL
or Access SQL which isn't in the list.

I have an Access 2007 Database on one Windows 2003 server. This database
has a linked table to a public folder full of supplier contacts on another
windows 2003 server which is hosted on Exchange 2003. I can change a contact
in access or in the public folder and the change sync's which is great
however I am trying to access this linked table from a web browser using
classic ASP which is hosted on the same server as the Access database) and I
have come across the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] There are no MAPI clients
installed on this machine. Install a MAPI client (like Outlook) on this

/cmsdev/SuppliersOverview.asp, line 17

Here's line 17 (very simple select statement):

set rs= objConn.execute("SELECT First, Last, Company FROM SuppliersLinked")

I have installed Outlook 2003 on the server and get the same error, even
when Outlook is running. I then uninstalled Outlook 2003 and then installed
Outlook 2007, same error.

I've had a look online and the solutions are pointing towards permissions
however the articles are referring to ASP.NET and not classic ASP which is
what I'm using. Plus some articles mention that a MAPI link needs to be
installed, if so how?

Any and all help is greatly appreciated, thanks in advance.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question