Testing outlook connection

[Nishikawa]

I have finally manage to get MS Access to interact with outlook (getting subject headers, attachments, edit categories fields) but soon realise that a new problem has emerge from this.

My outlook exchange server in my office is so unstable (don't ask me why, I know nuts about it) that when MS access start requesting for email details or to go through mails, everything else on my computer starts hanging.

Is there a way to test the connection betwwen MS access and outlook before MS acess sstart managing the emails? E.g. if outlook is taking more than 5 seconds to run a requeat, terminate the connection.

Is there threading capability in access to verify connection health ?

 

[darbid]

In short I do not have an answer.

My outlook exchange server in my office is so unstable (don't ask me why, I know nuts about it) that when MS access start requesting for email details or to go through mails, everything else on my computer starts hanging.

Are you sure it is your MsAccess code that does this. For example have you noticed that when you use Outlook that the exchange server is slow?

Is there a way to test the connection betwwen MS access and outlook before MS acess sstart managing the emails? E.g. if outlook is taking more than 5 seconds to run a requeat, terminate the connection.

maybe this will help as there is a very specific forum for Outlook
http://www.outlookcode.com/article.aspx?id=54

for example i think this is your answer
http://www.outlookcode.com/threads.aspx?forumid=4&messageid=22170

http://www.outlookcode.com/threads.aspx?forumid=4&messageid=10187

Generally you might start here and see what else you find
http://support.microsoft.com/kb/220595/

 

[joh024]

Here is a link to another forum that explains how to create a basic thread in VB. You might have to fiddle with it a bit to port it over to VBA. This is a windows specific function so you could probably search for the function name in google or something and see how it is done in other languages. It should be essentially the same. You just have to know how to process the new thread.

http://www.vbforums.com/showthread.php?t=43567