Access Database Shutsdown without Warning

[ekharonne]

Hey All,

Just curious if anyone has ever experience this issue. I have an Access 2003 application. Without rhyme or reason, it will just shutdown suddenly while you are in the middle of typing. No warning, it just shutsdown. I have done countless google searches for an answer but keep coming up empty. does anyone have any advice to get me in the right direction to fix the issue?

Thank You,
EK

 

[Mr. B]

As a starting point, are you able to duplicat the behavior. By this I mean, can you make this happen by taking specific actions? If so, what are the actions that cause it to happen?

If not, if you have any VBA code, try doing a compile of your code and see if you get any errors reported.

 

[ekharonne]

As of right now, I am unable to duplicate the error. I have been trying to test and see if it is a timing issue meaning if I leave the application open for a certain length of time will it shutdown unexpectedly. I am performing some tests with users today and hopefully i can offer more clues that will help diagnosis the cause.

 

[ekharonne]

Okay, I just ran a test by myself and after roughly 20 minutes, access shutdowns. I was not typing or using the application, just had it opened to see how long it would take to shutdown on its own. I have inherited this application so I am wondering if the previous coder may have coded a timer event into the application. If so, does anyone have an idea where he may have put that code?

 

[spikepl]

Is there an AutoExec macro?
Does the app have a Form that starts up as default ? In its code there might be an easter egg

 

[gemma-the-husky]

is it an mde or an mdb?

 

[ekharonne]

Hello Again,

Hey Husky, it is a mde. Spikepl, the only code I can see that may cause an issue is a function fAccessWindow that hides the Access menu and only shows the startup form. I can post the code from this function.

 

[SteveH2508]

Hello Again,

Hey Husky, it is a mde. Spikepl, the only code I can see that may cause an issue is a function fAccessWindow that hides the Access menu and only shows the startup form. I can post the code from this function.

If you have the code available then surely it must be an mdb file?
An mde file only contains compiled code - no source code.

Post the code if you can.

Have you tried starting the database with the shift key pressed? This should stop the auto exec macro running and thus might stop any timer routine/hidden form malarkey being initialised. Just a thought.