MSACCESS Error

[gobble]

I have a form that allows you to send e-mails to the person that the action has been assigned too. However it has recently been producing an MSACCESS error when you close down the database, and others have not been able to send e-mails. It was all working a few days ago!!

Does anybody know why this would be happening?

 

[thornmastr]

What is the error message? Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[gobble]

The message is "MSACCESS.exe has generated errors and will be closed by Windows. You will need to restart the program.
An error log is being created"

This happens when I close down my application and access.

 

[thornmastr]

The problem and possible resolution(s) are found in MSKB article Q148424. Having given you the official MS stance which takes the onus off of you, my suggestion is to look in code which does, or may do, strange things to memory block allocation.


When I had this problem it was finally tracked down to the fact that I was releasing the source object of a subform contained by an unbound main form. It took me a while to realize that MS, since my main form had no source object, assigned the source object of my sub form to the main form. When I released the source object everything crashed and burned around me. In this particular instance I assigned the main form a source object of a dummy table which allowed me to properly drop the source object of a sub form without any problems.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com