<!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>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=691332802-18022003><FONT face=Arial color=#0000ff size=2>Oh
cool, so we go buy visual studio to find them? Wouldn't an upgrade to
Win2K be cheaper (and gets you a real operating system in the bargain
;-)</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader 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>Bruce
Bruen<BR><B>Sent:</B> Monday, February 17, 2003 8:29 PM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] ODE VBA Error
Handler Crashes Access 2000<BR><BR></FONT></DIV>
<DIV><SPAN class=740382701-18022003><FONT face=Arial color=#0000ff size=2>The
Visual Studio tool, PView95.exe a.k.a. Process Viewer, finds and can remove
them - at least in my experience!</FONT></SPAN></DIV>
<DIV><SPAN class=740382701-18022003><FONT face=Arial color=#0000ff
size=2>Bruce</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>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com] <B>On Behalf Of </B>John W.
Colby<BR><B>Sent:</B> Tuesday, February 18, 2003 11:52 A<SPAN
class=740382701-18022003><FONT face=Arial
color=#0000ff> </FONT></SPAN><BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD] ODE VBA Error
Handler Crashes Access 2000<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=303374700-18022003>><FONT color=#000000>Also when MS Access crashes
use Ctrl+ALT+DEL to open Task Manager and to see that you may have ghost MS
Access processes running - remove them</FONT></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#000000 size=2><SPAN
class=303374700-18022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#000000 size=2><SPAN
class=303374700-18022003>This brings up another very real reason why Windows
98/me sucks. I have seen cases where instances of Access were hanging
around. They are visible in the Processes tab of Win2K's task manager
but are not visible in the Applications tab or in Windows 98 / ME. In
A2K you can just look in the Processes tab, find them, and shut them
down. In Windows 98 / ME, they can't be seen at all so you don't even
know they are still loaded - until you start running into the swap file that
is. Rebooting Windows 98 is the only way to remove these
ghosts.</SPAN></FONT></DIV>
<P><FONT size=2>John W. Colby<BR>Colby
Consulting<BR>www.ColbyConsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader 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>Shamil
Salakhetdinov<BR><B>Sent:</B> Monday, February 17, 2003 7:27
PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] ODE VBA Error Handler Crashes Access 2000<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><<<</FONT></DIV>
<DIV><SPAN class=114542023-17022003><FONT face=Arial size=2>(2) how to
avoid having to log off to correct the 'Locked by Admin'
error.</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2>>>></FONT></DIV>
<DIV><FONT face=Arial size=2>Myke,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Try to use rotclean.exe after Access crashes
- it was here:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>Internet (anonymous FTP)<BR> ftp
ftp.microsoft.com<BR> Change to the
Softlib\Mslfiles directory<BR> Get
ROTCLN32.EXE</DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Also when MS Access crashes use Ctrl+ALT+DEL
to open Task Manager and to see that you may have ghost MS Access
processes running - remove them, then run rotclean.exe. RotView.exe
(from VS6) can be used to see hanging ROT objects left by crashed MS
Access....</FONT><BR></DIV>
<DIV><FONT face=Arial size=2>HTH,</FONT></DIV>
<DIV><FONT face=Arial size=2>Shamil</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=mmmtbig@bellsouth.net href="mailto:mmmtbig@bellsouth.net">Myke
Myers</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, February 18, 2003
2:31 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] ODE VBA Error
Handler Crashes Access 2000</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2><SPAN class=114542023-17022003>I've been
working on an Access 2000 frontend for several hours -- testing and
debugging some reports. I'm in a module looking at a sub procedure that
I just documented. I decide to add an error handler using the ODE tool
from the Add Ins list. I ALWAYS save before I run
this.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=114542023-17022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=114542023-17022003>It crashes
Access (happens about once a week). When I open the frontend I was
working on and try to repair/compact, I get the dreaded 'File is locked
by user Admin' error.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=114542023-17022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=114542023-17022003>I log off
Admin and log on again. Open the app, run repair/compact, and go back to
work.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=114542023-17022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=114542023-17022003>No disaster,
but 20 - 30 minutes lost. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=114542023-17022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=114542023-17022003>Anyone have
any suggestions about </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=114542023-17022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=114542023-17022003>(1) why the
VBA Error Handler Add-In crashes occasionally, and </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=114542023-17022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=114542023-17022003>(2) how to
avoid having to log off to correct the 'Locked by Admin'
error.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=114542023-17022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=114542023-17022003>TIA,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=114542023-17022003>Myke</SPAN></FONT></DIV></BLOCKQUOTE></BLOCKQUOTE>
<DIV>
<HR>
</DIV>
<DIV>Is email taking over your day? Manage your time with eMailBoss. Try it
free! <A
href="http://www.eMailBoss.com">http://www.eMailBoss.com</A></DIV></BLOCKQUOTE></BLOCKQUOTE>
<DIV>
<HR>
</DIV>
<DIV>Is email taking over your day? Manage your time with eMailBoss. Try it
free! <A
href="http://www.eMailBoss.com">http://www.eMailBoss.com</A></DIV></BODY></HTML>