<!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 dir=ltr>
<DIV><SPAN class=261500101-07032003><FONT face="Comic Sans MS" color=#0000ff
size=2>Now that's very interesting. I'll keep it in mind. I actually
rewrote the code reattaching the tables or refreshing the link and the problem
went away. I can't see why, so this may be useful
information.</FONT></SPAN></DIV>
<DIV><SPAN class=261500101-07032003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=261500101-07032003><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> Eric Goetz
[mailto:accessd-admin@databaseadvisors.com] <B>On Behalf Of </B>Eric
Goetz<BR><B>Sent:</B> Thursday, March 06, 2003 4:41 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>Hi Charlotte,</DIV>
<DIV> </DIV>
<DIV>I'm not sure if you've solved your hang problem yet. Did you?</DIV>
<DIV> </DIV>
<DIV>I had a problem with mysterious hang conditions with linked tables
with fe/be mde's in the same directory with both Access XP
and 97. I went through months of trial and worked with MS support for weeks
trying different configurations and updates. In the end, it turned out to be
path length! Apparently, I had buried the directory under too many
subdirectories. I moved the directory closer to the root directory, and I
haven't had a single hang in months!</DIV>
<DIV> </DIV>
<DIV>Good luck,</DIV>
<DIV> </DIV>
<DIV>Eric</DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT size=2>-----Original Message----- <BR><B>From:</B> Charlotte
Foust [mailto:cfoust@infostatsystems.com] <BR><B>Sent:</B> Mon 3/3/2003 2:38
PM <BR><B>To:</B> AccessD@databaseadvisors.com <BR><B>Cc:</B>
<BR><B>Subject:</B> [AccessD] Access XP and 97 hang on reattaching linked
tables under WinXP<BR><BR></FONT></DIV>
<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>