[AccessD] ODE VBA Error Handler Crashes Access 2000

Myke Myers mmmtbig at bellsouth.net
Mon Feb 17 17:30:00 CST 2003


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/d54b58ce/attachment-0001.html>


More information about the AccessD mailing list