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>