PC Review


Reply
Thread Tools Rate Thread

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

 
 
Neil
Guest
Posts: n/a
 
      9th Jul 2008

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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I save en email message form on my exchange server public fold Bob Microsoft Outlook Discussion 0 1st May 2009 05:15 PM
Re: How to prevent Outlook from caching data in forms from public fold Hollis Paul Microsoft Outlook Form Programming 3 25th Jan 2007 05:43 PM
Link Access Table to Exchange Public Folder Contacts Brian Microsoft Outlook Contacts 0 29th Jan 2006 08:05 PM
Editing Exchange Public Folder data in Access Danny Costa Microsoft Access External Data 1 12th May 2004 07:52 AM
ODBC, Access Linked tables to Exchange data Patrick M. Microsoft Access External Data 1 31st Dec 2003 11:30 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:47 AM.