<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=593364323-03032003><FONT face=Arial color=#0000ff
size=2>Charlotte,</FONT></SPAN></DIV>
<DIV><SPAN class=593364323-03032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593364323-03032003><FONT face=Arial color=#0000ff size=2>I had
a similar problem when trying to send email with Access2K/XP under
either Win2K or WinXP (with or without Redemption; it didn't matter if Outlook
was open or not; but I didn't have the current db opened in a 2nd DAO
worspace). I found that if there was an error in my send Email procedure
that the instance of Outlook that was initiated through the send Email procedure
was not closing. Consequently, two instances of Outlook was running.
The next time I tried to send an email through the Email procedure, Access would
sometimes hang, but Outlook would always hang. Using the Task
Manager to stop all instances of Outlook and/or Access did not always make
things right so I ended up doing a reboot to get everything to work
properly. </FONT></SPAN></DIV>
<DIV><SPAN class=593364323-03032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593364323-03032003><FONT face=Arial color=#0000ff size=2>I
found through trial and error that the Outlook resources initiated in the Email
procedure were not being released. When I changed the procedure to insure
that these resource were released, even if an error occured, my problem was
resolved. Evidently, in my case anyway, Win2K and WinXP do not like two
instances of Outlook running.</FONT></SPAN></DIV>
<DIV><SPAN class=593364323-03032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=593364323-03032003><FONT face=Arial color=#0000ff size=2>If you
are using the code I sent you, but you modified it so that the releasing of
resources in not after the SendEmail_Exit Label, or that you've removed the
error trapping portion, or you've modified the error trapping whereby you
are bypassing the releasing of resources, that might be your culprit.
</FONT></SPAN></DIV>
<DIV><SPAN class=593364323-03032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV><!-- Converted from text/rtf format -->
<P><B><I><FONT face="Times New Roman" color=#0000ff size=4>John V.
Ruff</FONT><FONT face="Times New Roman" size=4> – </FONT><FONT
face="Times New Roman" color=#008080 size=4>The Eternal Optimist</FONT><FONT
face="Times New Roman" size=4></FONT> <FONT face=Wingdings color=#800080
size=4>J</FONT></I></B> <BR><I><FONT face="Times New Roman">Always Looking For
Contract Opportunities</FONT></I> </P>
<P><A href="http://www.noclassroom.com/"><U><FONT face="Times New Roman"
color=#0000ff>www.noclassroom.com</FONT></U></A> <BR><FONT
face="Times New Roman" color=#ff00ff>Live software training</FONT> <BR><FONT
face="Times New Roman" color=#ff00ff>Right over the Internet</FONT> </P>
<P><FONT face="Times New Roman" size=2>Home: 253.588.2139</FONT> <BR><FONT
face="Times New Roman" size=2>Cell: 253.307/2947</FONT> <BR><FONT
face="Times New Roman" size=2>9306 Farwest Dr SW</FONT> <BR><FONT
face="Times New Roman" size=2>Lakewood, WA 98498</FONT> </P>
<P><B><FONT face="Times New Roman" color=#000080 size=2>“Commit to the Lord
whatever you do,</FONT></B> <BR><B>
<FONT face="Times New Roman" color=#000080 size=2>and your plans will succeed.”
Proverbs 16:3</FONT></B> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com]
<B>On Behalf Of </B>Charlotte Foust<BR><B>Sent:</B> Monday, March 03, 2003
2:39 PM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] Access XP and 97 hang on reattaching linked tables under
WinXP<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face="Comic Sans MS" size=2>We're beating our heads against this
one. Under certain specific circumstances, both Access XP and 97 will
hang running under WinXP. The circumstances are that Outlook is running
(either 2000 or XP) and you toggle to the Outlook application during a portion
of the operation when Access is trying to reattach files using an instance of
the current database opened in a second DAO workspace. I'm trying to
track down anything on this problem and haven't had much luck. There are
articles about the ODBC drivers in multithreaded environments, but they seem
to apply more to SQL Server links and are supposed to be fixed by the latest
installation of Jet 4.x. Not on my machine, they aren't.</FONT></P>
<P><FONT face="Comic Sans MS" size=2>Does anyone have any more information on
this issue? We're also getting reported hangs after an email is sent by
our application on a client's WinXP machine, but we haven't been able to
replicate that. The primary suspect in both cases is Outlook, even
though we use the Redemption library to bypass the direct MAPI calls.
</FONT></P>
<P><FONT face="Comic Sans MS" size=2>Suggestions?</FONT> </P>
<P><FONT face="Comic Sans MS" size=2>Charlotte Foust</FONT>
</P></BLOCKQUOTE></BODY></HTML>