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

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

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
machine.

/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.
Neil
 
Back
Top