<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=510161605-04032003><FONT face=Arial color=#0000ff size=2>We use
an external control to make SMTP with A2k, is the same using A2k and AXP with
W2k or W98SE. In other side we check the hang and don't occur on machines who
use only Microsoft applications, but if you install some another libraries then
some problems with hang appear.</FONT></SPAN></DIV>
<DIV><SPAN class=510161605-04032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=510161605-04032003><FONT face=Arial color=#0000ff size=2>Check
Fath Software to see his SMTP control, is cheap and friendly to use in
Access</FONT></SPAN></DIV>
<DIV><SPAN class=510161605-04032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=510161605-04032003><FONT face=Arial color=#0000ff size=2>Juan
Menendez</FONT></SPAN></DIV>
<DIV><SPAN class=510161605-04032003></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Mensaje original-----<BR><B>De:</B>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com]<B>En nombre de </B>Charlotte
Foust<BR><B>Enviado el:</B> martes, 04 de marzo de 2003 02:03<BR><B>Para:</B>
accessd@databaseadvisors.com<BR><B>Asunto:</B> RE: [AccessD] Access XP and 97
hang on reattaching linked tables under WinXP<BR><BR></FONT></DIV>
<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></BLOCKQUOTE></BODY></HTML>