<!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.2722.900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<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> </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></BODY></HTML>