Access 2000 and linking to Exchange/Outlook

[Jayson]

Hello there!

I'm currently using Access 2000 to create an application. One of the link tables that i'm using is a link to Exchange/Outlook's Inbox. So basically, what i get is a link table which contains the content of my Outlook's Inbox.

The problem is i want to be able to assign the Inbox/Mailbox that i'm using dynamic, depending on which workstation my application is running. I'm trying to use "DoCmd.TransferDatabase" to re establish the link to another Inbox/Mailbox, but it doesn't let me...apparently, the only way to do it right now, is to drop the link and re establish the link onto another person's mailbox manually.

Is there a better way to do this? a function or something?

Thanks for any help

 

[tlbroadbent]

Take a look at this article.

ACC2000: Sample Procedure to Link a Microsoft Outlook Folder

http://support.microsoft.com/support/kb/articles/Q209/9/46.ASP

Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[Jayson]

Thats was exactly what i needed, thank you very very much!
your a life saver!