<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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></BODY></HTML>