<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=237360001-04032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Thanks for the suggestion, John. Unfortunately, in our case,
Outlook doesn't hang, only Access. Interestingly enough, on some of our
machines, if Outlook is minimized, the Access doesn't hang, but if it is open on
the desktop, even if Access is on top, then Access hangs when it tries to
reconnect to its own back end. I'm going to rewrite the code to reattach
the tables and see if new code using DAO (there are reasons) but written
entirely from scratch, will behave the same way.</FONT></SPAN></DIV>
<DIV><SPAN class=237360001-04032003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=237360001-04032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<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> John Ruff
[mailto:papparuff@attbi.com] <BR><B>Sent:</B> Monday, March 03, 2003 4:07
PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Access XP and 97 hang on reattaching linked tables under
WinXP<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BODY></HTML>