[AccessD] ODE VBA Error Handler Crashes Access 2000

Message<<<
(2) how to avoid having to log off to correct the 'Locked by Admin' error.
>>>
Myke,

Try to use rotclean.exe after Access crashes - it was here:

Internet (anonymous FTP)
      ftp ftp.microsoft.com
      Change to the Softlib\Mslfiles directory
      Get ROTCLN32.EXE

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....

HTH,
Shamil
  ----- Original Message ----- 
  From: Myke Myers 
  To: accessd at databaseadvisors.com 
  Sent: Tuesday, February 18, 2003 2:31 AM
  Subject: [AccessD] ODE VBA Error Handler Crashes Access 2000


  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.

  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.

  I log off Admin and log on again. Open the app, run repair/compact, and go back to work.

  No disaster, but 20 - 30 minutes lost. 

  Anyone have any suggestions about 

  (1) why the VBA Error Handler Add-In crashes occasionally, and 

  (2) how to avoid having to log off to correct the 'Locked by Admin' error.

  TIA,
  Myke
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030217/9e761f68/attachment-0002.html>