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
|