Programatically Linking to an Outlook Public Folder.

[A Dubey]

I have an application that uses two MS Exchange 2000
Public folders to look up v-card/contact info.

The app is Access 2002 Runtime, and the users do not have
access to the linked table manager.

I can link the folders my self, but when someone other
than myself opens the App, it prompts them for an
exchange/outlook profile to use. This is because the
profile is stored in mySysObjects table.

ie: The database field is populdated with the following.

Outlook 9.0;MAPILEVEL=Public Folders|All Public
Folders\Audit Response\;PROFILE=Arthur
Dubey;TABLETYPE=0;TABLENAME=Team Members;

The following code works fine for linking SQL ODBC
Tables, but I have not been able to find syntax for
connecting to an Outlook Source.

If I could update the record in mySysObjects to reflect
the user profile change, this would be easy, but even
after giving "Admin" full rights to the sys tables,
Access will not allow modification. (Is there a way
around this?)

DoCmd.TransferDatabase acLink, "ODBC Database", _
"ODBC;DSN=LendSync;Description=LendSync; _
DATABASE=LendSyncSQL;Network=DBMSSOCN; _
DATABASE=LendSyncSQL;Trusted_Connection=Yes", _
acTable, ForeignName, Name

Thanks,

AD

 

[Ian Baker]

Hi AD
Have you had a look at using the Outlook View Control and incorporate
Outlook within your app.

 

[A Dubey]

Actually this is the first time I have integrated with
Outlook. This app also brings in an Outlook Template and
pre-populates all of the fields. I am using the
Msoutl.olb ver 10.0 for my lib ref. All of this works
fine, the only problem I have is with the links that feed
two combo boxes.

AD