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