Accessing Outlook on another workstation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I asked this on the Access forum but didn't get a workable answer.
I have
an access application that will be running on multiple workstations on a
network. One of those workstations will have the Access DB that has the
tables, which the application will be linked to, and will also have Outlook
running, being used as a central appointment scheduler. I want my Access appl
to be able to look at the Outlook appointments, regardless of which
workstation they are running on. The way I have it set up right now Access
only looks at the Outlook that is running on the same workstation. How do I
connect to Outlook on a different machine? Here's how I am currently opening
my Outlook connection:

Set objOutlook = CreateObject("Outlook.Application")
Set outlookNS = objOutlook.GetNamespace("MAPI")

I tried using GetObject("Outlook.Application","computerName") instead of
CreateObject, but that gives me an error.

Any help is greatly appreciated!
 
Outlook will possibly only be running on the one workstation. I want to run a
distributed Access application, with Office only on the workstation that will
be running Outlook.
 
Assuming that Outlook can be used over DCOM (which I have no idea but
wouldn't be surprised if not), DCOM is hard to setup and insecure.

Depending on your familiarity with .NET, such an application would be
fairly easy to expose via a .NET remoting service in an Add In. But that's a
major architectural change. The only tricky part is making sure the Outlook
API is only accessed on the UI thread. You could do that with an invisible
form or something.

--
Josh Einstein
Einstein Technologies
Microsoft Tablet PC MVP
Tablet Enhancements for Outlook 2.0 - Try it free for 14 days
www.tabletoutlook.com
 
I don't know what DCOM is. I'm using Access 2000, and simply want the ability
to look at Outlook folders from a workstation other than the one where the
Access application is running.
 
Right, what you were trying to do, using GetObject to retrieve an object
reference on another machine is DCOM. It's fairly complex and insecure.

--
Josh Einstein
Einstein Technologies
Microsoft Tablet PC MVP
Tablet Enhancements for Outlook 2.0 - Try it free for 14 days
www.tabletoutlook.com
 
Back
Top