> I was happily coding away when all of the sudden when I ran a certain
> function VB6 would crash without warning. I was offered to debug and got the
> message "unhandled exception in msjet40.dll" I tried reinstalling VBS6,
> office 97. Not luck.
> I sepped through the function that was appeared to be crashing and it ran
> fine until the end of the End Function statement, then crashed. I even
> renamed the msjet40.dll to amsjet40.dll and still had the same problem. I
> dont even think I use msjet40.dll, I use MSjet3.5.
> I eventually created a new project and basically cut and pasted my old code
> into the new project and it seems to work now.
> I am at a loss. I dont know how I broke it, or what exactly fixed it. A
> google search for the error produced less than usefull information so I am
> once again in the NG looking for help. Has anyone had this problem before?

> Thanks Rob