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!

Did you try Namespace.GetSharedDefaultFolder (assuming you are using
Exchange)?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Jim Burke in Novi" wrote in
message ...
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.

"Dmitry Streblechenko" wrote:

Did you try Namespace.GetSharedDefaultFolder (assuming you are using
Exchange)?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Jim Burke in Novi" wrote in
message ...
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!

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


"Jim Burke in Novi" wrote in
message ...
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!

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.

"Josh Einstein" wrote:

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


"Jim Burke in Novi" wrote in
message ...
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!

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


"Jim Burke in Novi" wrote in
message ...
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.

"Josh Einstein" wrote:

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


"Jim Burke in Novi" wrote in
message ...
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!